Description
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.…
Highlights
- Pipe-style syntax for filtering, grouping and counting JSON
- JavaScript build with no dependencies, about 5.5 kB gzipped
- Python implementation for server-side use
- The same queries can run on the frontend and the backend
- Tutorial and an in-browser Try it out page
Ratings & Reviews
No ratings yet
Be the first to rate MistQL.
People also visit
mongodb/mongodb-natural-language-querying
Translate natural language into MongoDB queries and aggregation pipelines
MistQL FAQ
What is MistQL?
A query language for JSON-like structures. You write chained expressions to filter, group and count data.
Where can it run?
In the browser with the JavaScript build, or on a server with JavaScript or Python. The site says the same functions can be shared between frontend and backend.
Is it free?
The source code is public on GitHub, and the site lists no price.
How does it compare to JMESPath and JSONLogic?
The site has a section that compares MistQL with both, explaining the differences in approach.
How do I start?
Open the getting started page, or the Try it out page, which runs queries in the browser.
What are the best MistQL alternatives?
Popular alternatives to MistQL include JSON Query, simplql and JSON Query. See all MistQL alternatives





