jsonq - A PHP query builder for JSON

•    PHP

---

JsonQ is a simple, elegant PHP package to Query over any type of JSON Data. It'll make your life easier by giving the flavour of an ORM-like query on your JSON. You can start Query your data using the various query methods such as find, where, orWhere, whereIn, whereStartsWith, whereEndsWith, whereContains and so on. Also you can aggregate your data after query using sum, count, groupBy, max, min etc.

json json-data json-query jsonq json-manager php-json

gojsonq - A simple Go package to Query over JSON Data

•    Go

---

You can query your document using the various query methods such as Find, First, Nth, Pluck, Where, OrWhere, WhereIn, WhereStartsWith, WhereEndsWith, WhereContains, Sort, GroupBy, SortBy and so on. Also you can aggregate data after query using Avg, Count, Max, Min, Sum etc. If you encounter any bugs or issues, feel free to open an issue at github.

gojsonq golang-json-query go-json go-json-query json-query json query golang-json golang-query go-query gojsonquery jsonq

jsonq - simple json field access for golang

•    Go

---

Simplify your golang json usage by extracting fields or items from arrays and objects with a simple, hierarchical query. API Documentation on godoc.org.This package is meant to make working with complex feeds a bit more easy. If you have simple feeds you want to model with struct types, check out jflect, which will create struct definitions given a json document.

json-query - Retrieves values from JSON objects for data binding

•    Javascript

---

Retrieves values from JSON objects for data binding. Offers params, nested queries, deep queries, custom reduce/filter functions and simple boolean logic. Specify a query and what to query. Returns an object that describes the result of the query.

data-binding filter json query

jsquery - JsQuery – json query language with GIN indexing support

•    C

---

JsQuery – is a language to query jsonb data type, introduced in PostgreSQL release 9.4. It's primary goal is to provide an additional functionality to jsonb (currently missing in PostgreSQL), such as a simple and effective way to search in nested objects and arrays, more comparison operators with indexes support. We hope, that jsquery will be eventually a part of PostgreSQL.

jsonb gin query-language json json-query

Defiant JS - Lightning-fast searches on JSON using XPath expressions, and transform JSON using XSLT

•    Javascript

---

DefiantJS provides the ability for you to build smart templates applicable on JSON structures, based upon proven & standardized technologies such as XSLT and XPath. DefiantJS also extends the global object JSON with the method "search", which enables searches on JSON structures with XPath expressions and returns matches as an array-like object.

xpath xslt web-worker json search browser xpath-queries query node

lowdb - Small local JSON database powered by Lodash (supports Node, Electron and the browser)

•    Javascript

---

lowdb is a small local JSON database powered by Lodash (supports Node, Electron and the browser). It supports atomic write, Query and modify data using plain JS, Change storage, file format (JSON, YAML, ...) or add encryption via adapters.

database lodash nodejs localstorage electron json embedded-database flat file local storage embed javascript-database json-database

json-mask - Tiny language and engine for selecting specific parts of a JS object, hiding the rest.

•    Javascript

---

This is a tiny language and an engine for selecting specific parts of a JS object, hiding/masking the rest.The main difference between JSONPath / JSONSelect and this engine is that JSON Mask preserves the structure of the original input object. Instead of returning an array of selected sub-elements (e.g. [{a: 1}, {z: 1}] from example above), it filters-out the parts of the object that you don't need, keeping the structure unchanged: {p: {a: 1}, z: 1}.

mask filter select fields projection query json

dasel - Query, update and convert data structures from the command line

•    Go

---

Dasel (short for data-selector) allows you to query and modify data structures using selector strings. Comparable to jq / yq, but supports JSON, YAML, TOML, XML and CSV with zero runtime dependencies.

config cli yaml toml parser json query portable xml configuration update selector data-structures xml-parser devops-tools yaml-processor json-processing

jmespath.js - Javascript implementation of JMESPath, a query language for JSON

•    Javascript

---

jmespath.js is a javascript implementation of JMESPath, which is a query language for JSON. It will take a JSON document and transform it into another JSON document through a JMESPath expression. In the example we gave the search function input data of {foo: {bar: {baz: [0, 1, 2, 3, 4]}}} as well as the JMESPath expression foo.bar.baz[2], and the search function evaluated the expression against the input data to produce the result 2.

jmespath jsonpath json xpath

js-search - JS Search is an efficient, client-side search library for JavaScript and JSON objects

•    Javascript

---

JS Search is an efficient, client-side search library for JavaScript and JSON objects

search database indexing performance js clientside client-side local query

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

•    Svelte

---

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.

electron mysql sql sql-server mongodb sqlite postgresql database-gui database-manager database-tools

query-server - Query Server Search Engines https://query-server.herokuapp.com

•    Python

---

The query server can be used to search a keyword/phrase on a search engine (Google, Yahoo, Bing, Ask, DuckDuckGo, Baidu, Exalead, Quora, Parsijoo, Dailymotion, Mojeek and Youtube) and get the results as json, xml or csv. The tool also stores the searched query string in a MongoDB database for analytical purposes.

jsonpath - Query and manipulate JavaScript objects with JSONPath expressions

•    Javascript

---

Query JavaScript objects with JSONPath expressions. Robust / safe JSONPath engine for Node.js. Here are syntax and examples adapted from Stefan Goessner's original post introducing JSONPath in 2007.

jsonpath json-path object traversal json path data-structures

trefle-api - 🍀 Trefle is a botanical JSON REST API for plants species, allowing you to search and query over all the registered species, and build the next gardening apps and farming robots

•    Ruby

---

⚠️ Unfortunately, Trefle is over for now. 🍀 Trefle is a botanical JSON REST API for plants species, allowing you to search and query over all the registered species, and build the next gardening apps and farming robots.

database plants api-rest biodiversity hacktoberfest trefle trefle-api plants-species gardening-apps farming-robots

RethinkDB - Distributed JSON database

•    C++

---

RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn. It supports JSON data model, Distributed joins, subqueries, aggregation, atomic updates, Hadoop-style map/reduce.

document-store document-database nosql-database json-store json-database distributed nosql

telize - Telize is a JSON IP and GeoIP REST API (IP Geolocation) built on Nginx and Lua

•    Lua

---

Telize is a REST API built on Nginx and Lua allowing to get a visitor IP address and to query location information from any IP address. It outputs JSON-encoded IP geolocation data, and supports both JSON and JSONP.Geolocation operations are performed using Nginx GeoIP module which caches the database in RAM. Therefore, Telize has very minimal overhead and should be blazing fast.

nginx geoip api json

VueDatatable - Bulma themed, VueJS powered Datatable with server-side loading and JSON template setup

•    PHP

---

Data Table package with server-side processing and VueJS components. Build fast any complex table based on a JSON template.

datatable datatables vue-datatable vuejs bulma json-template laravel-enso vue-table serverside vuejs-components pagination demo

Mirage - An interactive query explorer for Elasticsearch

•    Typescript

---

Mirage is a modern, open-source web based query explorer for Elasticsearch. It offers a blocks based GUI for composing Elasticsearch queries and comes with an on-the-fly transformer to show the corresponding JSON query API of Elasticsearch.

elasticsearch-management elasticsearch-tools elasticsearch-client elasticsearch-monitoring

queryl - :mag_right: Query language to perform complex object searches

•    Javascript

---

Query language to perform complex object searches.

query object json search