Permission-gated SQL
Every SQL statement is parsed with Microsoft ScriptDom in memory and validated against effective permissions before transmission.
Centralise database access, enforce strict AST query gates, mask sensitive PII on the fly, and guarantee a tamper-evident audit trail without sharing raw database credentials.
| Order ID | Customer | Total | Status |
|---|---|---|---|
| 101 | Acme Logistics | $1,420.00 | Shipped |
| 102 | Global Tech Corp | $850.50 | Shipped |
| 103 | Summit Retail | $3,110.00 | Shipped |
See what users experience after logging in: compact navigation, schema object exploration, ScriptDom AST gate checks, in-flight masking, and visual explain plans.
| # | id | customer_name | order_date | status | total |
|---|---|---|---|---|---|
| 1 | ORD-9821 | Apex Logistics | 2026-11-17 | Delivered | $4,820.00 |
| 2 | ORD-9820 | Vanguard Systems | 2026-11-17 | Processing | $1,290.00 |
| 3 | ORD-9819 | Cascade Media | 2026-11-16 | Delivered | $875.00 |
| 4 | ORD-9818 | Northwind Labs | 2026-11-16 | Delivered | $2,450.00 |
From initial engine registration to immutable audit logs, Query Gate inserts security guardrails without interrupting developer workflows.
Connect SQL Server, PostgreSQL, MySQL or MariaDB with dedicated least-privilege credentials.
Assign granular role permissions, schema whitelists, and temporary time-window countdowns.
ScriptDom AST parses queries in memory. Prohibited statements are rejected fail-closed.
Pre-execution audit writes guarantee every query is logged with actor, hash, and duration.
Query Gate maintains single-tenant connection pools with encrypted credentials. Users never see or touch the database connection strings, passwords, or network endpoints.
Automatically redact sensitive PII including credit card numbers, email addresses, and national IDs for PCI-DSS, GDPR, and HIPAA compliance without altering underlying table data.
| Data Field | Compliance Standard | Storage in Database | Query Gate In-Flight Output |
|---|---|---|---|
| Primary Account Number | PCI-DSS Requirement 3.4 | 4532 8901 2341 4242 | •••• •••• •••• 4242 |
| Cardholder CVV / CVC | PCI-DSS Requirement 3.2 | 849 | ••• (Redacted) |
Engineers get an agile SQL workspace while security teams and administrators retain total oversight.
Developers do not want to fill out ticket queues just to inspect an order record or run a SELECT statement. Query Gate provides an integrated Monaco SQL workspace with autocomplete, tab management, and instant explain plan analysis.
Designed for organizations that require strict security, compliance oversight, and high developer productivity.
Every SQL statement is parsed with Microsoft ScriptDom in memory and validated against effective permissions before transmission.
Control access at database, schema, table, and view levels with role-specific whitelists and blacklists.
In-flight redaction protects card numbers, emails, and medical identifiers for HIPAA, GDPR, and PCI-DSS compliance.
Inspect query execution plans, operator tree hierarchies, and node costs to identify bottlenecks before execution.
Export results directly to CSV, Excel (.xlsx, .xlsb), JSON, Markdown, or runnable SQL INSERT scripts.
Manage role and user grants, review access approval requests, and enforce temporary expiring access windows.
Fail-closed architecture guarantees a persistent audit row write before any statement reaches the database engine.
Explore database objects, write queries with autocomplete, and manage multiple query tabs in one unified interface.
Sign in with WebAuthn passkeys or TOTP authenticator apps for modern, phishing-resistant security.
Query Gate runs wherever .NET 10 and PostgreSQL are supported. Pick a deployment target below to view setup instructions.
Explore the source code, review security implementations, report issues, or contribute new database providers.
Application-level permissions complement native database permissions. Use dedicated least-privilege accounts, enforced TLS, and protected connection strings.