Thriving Thriving Python PY
โ†‘ 72 ?
QueryAPIGate AnanthaRajuC/QueryAPIGate

Self-hosted gateway that turns saved SQL queries into versioned REST endpoints with typed, injection-safe parameters. Scoped API keys and roles, per-user JWT sign-in with row-level binding, run history, live SSE events and an admin UI. Postgres, MySQL, ClickHouse, SQLite, DuckDB, H2, MongoDB and JDBC

https://anantharajuc.github.io/QueryAPIGate-website/Home.dc.html โ†—
HEALTH ? 89 / Healthy
// solo builder// hidden gem// release machine apimysqlpythonsqlclickhouseflasksqliteapi-gatewaydata-apidata-engineering ?

// readme

QueryAPIGate

Turn SQL into governed data access: REST APIs for your apps, MCP tools for your AI agents.

Full documentation

     alt="One governed gate between your databases and everything that asks them for data: apps, partners, AI agents, people and pipelines come in through five front doors - REST endpoints, the MCP server, live events, exports and the CLI, the Management API - and every call passes the same governed core (identity, policy, execution) before it reaches PostgreSQL, MySQL, SQLite, DuckDB, ClickHouse, MongoDB, the experimental H2 and JDBC, files through DuckDB, or deliveries to object storage" width="820">

     alt="What happens to every request, one partner call followed through eight stages: identify the caller, apply its limits, check the grant, validate parameters, guard the SQL, run it, mask and format, record it - a stage that fails stops the call with a typed error code" width="820">

QueryAPIGate is a self-hosted gateway between your databases and everything that asks them for data. Save a SQL query once, and it is both:

  • a REST endpoint for apps, partners and pipelines:โ€ฆ