Skip to content
MistQL

Open source alternatives to MistQL

200 open source 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. 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

  3. 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

  4. 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

  5. S

    Svelte Jsoneditor

    Launch

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

    Open source

  6. M

    Murex

    Launch

    murex is a shell and scripting environment that aims to be smarter and easier to read than traditional shells. It has native support for structured data such as JSON, YAML, XML and CSV, so you can work with data directly rather than parsing

    Open source

More like MistQL

7
F

Flask Jsondash

Build complex dashboards without any front-end code

Launch
8
Q

Query Translator

Query Translator is a search query translator with AST representation

Launch
9
S

Slowql

Next-generation SQL static analyzer written in Rust

Launch
10
L

Log Voyager

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

Launch
11
D

DBT Osmosis

Provides automated YAML management and a streamlit workbench

Launch
12
M

MetriQL

Headless business intelligence suite

Launch
13
L

LibreDB Studio

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

Launch
14
Q

Quicktype

It's like Uber, but for JSON

Launch
15
D

data-peek

A minimal, fast, database client desktop application

Launch
16
D

Data Forge TS

The JavaScript data transformation and analysis toolkit inspired by Pandas

Launch
17
L

Lowdb

Simple and fast JSON database

Launch
18
M

Marmot

Data catalog for discovering and organizing data assets across your stack

Launch
19
M

mist.io

Mist is an open source multicloud management platform

Launch
20
P

Portable Data Stack Dagster

A portable Datamart and Business Intelligence suite

Launch
21
K

Kysely

A type-safe TypeScript SQL query builder

Launch
22
F

Franchise

A SQL Notebook

Launch
23
M

Markdowndb

Turn markdown files into structured, queryable data with JS

Launch
24
A

APIJSON

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

Launch
25
J

Just Dashboard

Dashboards using YAML or JSON files

Launch
26
M

Memento

Simple + Powerful interface to the Mnesia Distributed Database

Launch
27
C

Cirql

A flexible SurrealDB ORM & query builder with Zod powered validation

Launch
28
W

WhatTheDuck

WhatTheDuck is an open-source web application built on DuckDB

Launch
29
Q

QoreDB

Next Generation Database Client

Launch
30
Q

qryn

polyglot observability

Launch
31
D

Dockit

Agentic desktop GUI client for Elasticsearch, OpenSearch, DynamoDB

Launch
32
M

Mayfly Go

Browser-based management platform of machine, database

Launch
33
B

Blazer

Business intelligence made simple

Launch
34
J

Json Viewer

not only a JSON viewer

Launch
35
M

Metaflow

Automate data-driven applications, manage complex data pipelines

Launch
36
O

Openhare

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

Launch
37
M

Mistle

Open source background agents

Launch
38
V

Velite

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

Launch
39
Z

ZeQLplus

Open Source Terminal SQLite Database Browser

Launch
40
J

JSON Crack

Visualize JSON, YAML and CSV as interactive node graphs

Launch
41
Q

Quary

Open-source BI for engineers

Launch
42
B

BedquiltDB

A Mongo-like JSON doc store built on Postgres

Launch
43
D

dbtarzan

Database browser

Launch
44
J

julien040/anyquery

Query apps with SQL from a single local-first binary

Get
45
R

runekaagaard/mcp-alchemy

Access PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server and more

Get
46
I

Insights

Open Source Self-Hosted Business Intelligence Platform

Launch
47
D

Dory

AI-native SQL client for humans and agents

Launch
48
A

Anyquery

One SQL interface for 60+ tools (e.g., GitHub, Notion, Airtable)

Launch
49
K

Kinto

Minimal JSON storage platform

Launch
50
R

Rootprint

Open-source, self-hosted logs and traces

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