Skip to content
<- All products
// product

QueryProxy

Production data access, without production credentials.

Brand: Tignex

Visit sitequeryproxy.com

QueryProxy is an open-source, self-hosted tool that brings database access and query approval into one portal. The idea: production data stays reachable, but production credentials stop circulating.

Queries are checked first

Before a query runs it passes through the AST guard. UPDATE and DELETE without a WHERE clause are rejected, and a LIMIT is injected into the query. So a single forgotten WHERE cannot wipe a whole table.

Approval and execution

Queries go to DBA approval, which can be given from the web interface, Slack, or Teams. Execution is asynchronous. Results can be masked, and every action is written to an append-only audit log.

Databases and installation

PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite are supported. Install with Docker or on PHP 8.3+. For SQL Server the published Docker image is not enough; it needs a custom image with Microsoft’s ODBC driver.

Self-hosted, no hosted version

QueryProxy is deliberately offered self-hosted only; there is no hosted version. The project is licensed under AGPL-3.0 and is developed and published by Tignex. It is pre-1.0.

// Products

Key features

  • AST guard: UPDATE/DELETE without WHERE is rejected, LIMIT is injected
  • DBA approval through web, Slack, and Teams
  • Asynchronous execution
  • Result masking
  • Append-only audit log
  • PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite
  • Runs with Docker or on PHP 8.3+
// faq

Frequently asked questions

What is QueryProxy for?+

It is a portal for database access and query approval. It gives controlled, recorded access to production data without handing out production credentials.

Is there a hosted version?+

No, deliberately. QueryProxy is self-hosted; you run it on your own infrastructure.

Which databases are supported?+

PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite. The SQL Server driver is in the code, but the published Docker image ships without it, so SQL Server needs a custom image with Microsoft's ODBC driver.

What protects against dangerous queries?+

The AST guard parses the query: UPDATE and DELETE without a WHERE clause are rejected and a LIMIT is injected. Queries go through DBA approval, which can be given on the web, in Slack, or in Teams.

Is everything recorded?+

Yes. The audit log is append-only, and result masking can be applied.

How is it installed, and under which licence?+

It runs with Docker or on PHP 8.3+. The project is licensed under AGPL-3.0 and developed on GitHub. It is still pre-1.0.

Let’s build your next project together

Tell us your idea and we’ll design the right solution for you.

Get in touch