Skip to content
MistQL

Free alternatives to MistQL

200 free apps like MistQL, closest match first.

Top picks

  1. J

    JSON Query

    Launch

    JSON Query is a small, flexible and expandable query language for JSON data. A query is written as a pipeline of functions, where each function passes its result to the next, for example filtering a list of friends by city, sorting them by

    Open source

  2. J

    jq is like sed for JSON data - you can use it to slice and filter and map and transform structured...

  3. U

    Ucast

    Launch

    UCAST, short for Universal Conditions AST, is a set of JavaScript libraries for representing a set of conditions in a neutral form and translating it into other query languages. It is meant for passing filter conditions between an API and a

    Open source

  4. S

    Steampipe

    Launch

    Steampipe is an open-source tool that lets you query your cloud, code, logs and other data with SQL. It gives a common SQL interface across more than 150 data sources through plugins, with zero-ETL, so you do not have to copy data into a da

    Open source

  5. G

    GraphQL

    Launch

    GraphQL is a query language for APIs and a runtime for fulfilling those queries with your existing data.

  6. T

    Twig

    Launch

    Explore JSON, YAML, and HAR in your browser. Search, follow paths, and copy values. Files are processed locally and are not uploaded. Also available in your terminal.

    Open source

More like MistQL

7
S

Svelte Jsoneditor

A web-based tool to view, edit, format, repair, query, transform

Launch
8
M

Murex

A smarter shell and scripting environment

Launch
9
F

Flask Jsondash

Build complex dashboards without any front-end code

Launch
10
C

CodePrettify

Format, inspect & repair JSON—locally

Launch
11
Q

Query Translator

Query Translator is a search query translator with AST representation

Launch
12
S

Slowql

Next-generation SQL static analyzer written in Rust

Launch
13
J

JSON Kit

Modern Kit to Visualize, Diff, and Convert JSONs instantly. 100% Local

Launch
14
L

Log Voyager

Analyze huge log files (10GB+) instantly in your browser

Launch
15
D

DBT Osmosis

Provides automated YAML management and a streamlit workbench

Launch
16
M

MetriQL

Headless business intelligence suite

Launch
17
S

SQL Workbench

Query local & remote CSV, Parquet and JSON data

Launch
18
L

LibreDB Studio

Browser-based SQL IDE for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis

Launch
19
M

mongodb-natural-language-querying

Generate read-only MongoDB queries

Get
20
Q

Quicktype

It's like Uber, but for JSON

Launch
21
D

data-peek

A minimal, fast, database client desktop application

Launch
22
D

Data Forge TS

The JavaScript data transformation and analysis toolkit inspired by Pandas

Launch
23
L

Lowdb

Simple and fast JSON database

Launch
24
B

BlazeSQL

Quickly access data, transform English language input into SQL code

Launch
25
M

Marmot

Data catalog for discovering and organizing data assets across your stack

Launch
26
P

Portable Data Stack Dagster

A portable Datamart and Business Intelligence suite

Launch
27
K

Kysely

A type-safe TypeScript SQL query builder

Launch
28
F

Franchise

A SQL Notebook

Launch
29
M

Markdowndb

Turn markdown files into structured, queryable data with JS

Launch
30
A

APIJSON

Real-Time no-code, powerful and secure ORM providing APIs

Launch
31
J

Just Dashboard

Dashboards using YAML or JSON files

Launch
32
M

Memento

Simple + Powerful interface to the Mnesia Distributed Database

Launch
33
W

write-query

Write optimized SQL for your dialect with best practices

Get
34
C

Cirql

A flexible SurrealDB ORM & query builder with Zod powered validation

Launch
35
W

WhatTheDuck

WhatTheDuck is an open-source web application built on DuckDB

Launch
36
M

mongodb-skills

Official MongoDB agent skills for schema design, query tuning, search

Get
37
Q

QoreDB

Next Generation Database Client

Launch
38
Q

qryn

polyglot observability

Launch
39
P

prisma-next-queries

Write Prisma Next queries for Postgres, SQLite, or Mongo

Get
40
D

Dockit

Agentic desktop GUI client for Elasticsearch, OpenSearch, DynamoDB

Launch
41
E

elasticsearch-esql

Execute ES|QL (Elasticsearch Query Language) queries, use

Get
42
M

Mayfly Go

Browser-based management platform of machine, database

Launch
43
B

Blazer

Business intelligence made simple

Launch
44
S

SQLNet - Like Twitter with SQL

A social network that looks like Twitter, but you write SQL to do anything

Launch
45
S

spl-to-apl

Translates Splunk SPL queries to Axiom APL

Get
46
J

Json Viewer

not only a JSON viewer

Launch
47
O

Openhare

AI-powered desktop SQL client. Cross-platform. Built with Flutter

Launch
48
V

Velite

Turns Markdown / MDX, YAML, JSON, or others into app's data layer

Launch
49
M

mongodb

Work with MongoDB databases using best practices

Get
50
M

Marillo

Ask your database questions and get answers, CSVs, and charts instantly

Launch

About MistQL

M

MistQL

A query language for JSON-like structures

MistQL is a query language for JSON-like data that is written to run in the browser or on a server. Queries are chained with a pipe-style syntax, so you can filter events, group them and count the results in a few readable steps. The JavaScript version has no dependencies and is about 5.5 kB gzipped, which makes it small enough for size-limited frontends. A Python implementation arrived in version 0.4.5, so the same queries can be shared between a frontend and a backend. The site shows examples such as counting one event type, grouping all event types, finding the last entry in a sorted list and listing users who purchased before they signed up. The project began as a domain-specific language for extracting machine learning features in the frontend, and the site compares it with JMESPath and JSONLogic. A getting started page, a tutorial and a Try it out page let you run queries without installing anything. The source code is public on GitHub.

Price
Open source
Category
Developer Tools
Website
mistql.com