Enterprise SQL governance for PostgreSQL, SQL Server, MySQL & MariaDB

Give your team access.
Keep the guardrails.

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.

Open source .NET 10 & PostgreSQL SQL Server PostgreSQL MySQL MariaDB Passkeys & MFA
LIVE QUERY GATE SIMULATOR
01 SELECT order_id, customer_name, total_usd FROM public.orders WHERE status = 'shipped';
Target: PostgreSQL 16
GATE PASSED Audit logged
24 ms
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
Simulated demonstration. Actual application interface and rule enforcement may differ based on tenant database configuration.
AUTHENTIC POST-LOGIN EXPERIENCE

The governed query workspace, in action.

See what users experience after logging in: compact navigation, schema object exploration, ScriptDom AST gate checks, in-flight masking, and visual explain plans.

Query Gate · Governed SQL Workspace (Post-Login View)
Representational Preview · Actual UI May Differ
Query workspace Connected
2
AR
Arjun Reddy Developer (Least-Privilege)
orders_report.sql ×
customer_masking.sql ×
explain_joins.sql ×
+ New
30s
1-- Role: Developer (Whitelisted: SELECT on public.orders)
2SELECT id, customer_name, order_date, status, total
3FROM public.orders
4WHERE status IN ('Delivered', 'Processing')
5ORDER BY id DESC LIMIT 4;
Success38 ms · 4 row(s) returned
# 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
Representational Interface: Interactive simulation. Actual interface adapts to your assigned roles, permissions, and database engines.
Read details

Production workspaces feature a full Monaco SQL editor with IntelliSense autocomplete, resizable split panels, persistent tabs, and multi-format exports for CSV, Excel (.xlsx, .xlsb), JSON, Markdown, and SQL INSERT.

GOVERNANCE LIFECYCLE

Four steps to governed database access.

From initial engine registration to immutable audit logs, Query Gate inserts security guardrails without interrupting developer workflows.

STEP 01 IN ACTION

Zero Shared Root Passwords

Query Gate maintains single-tenant connection pools with encrypted credentials. Users never see or touch the database connection strings, passwords, or network endpoints.

TLS / SSL Enforced Secret Encryption Connection Health Check
Target Engine: PostgreSQL 16
Host & Port: pg-cluster.internal:5432
Service Account: svc_querygate_ro
Health status: Healthy (Round-trip 8ms)
Step 1 of 4
IN-FLIGHT DATA MASKING

Compliance without modifying the database.

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.

Simulated Role:
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)
BUILT FOR TEAMS

A shared workflow, different responsibilities.

Engineers get an agile SQL workspace while security teams and administrators retain total oversight.

Frictionless SQL with Autocomplete and Visual Plans

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.

Monaco Editor Visual Explain Export to CSV & Excel
Key Developer Advantage: No database credentials stored in local environments or shared in Slack channels. Simply open the browser, select a database, and execute allowed queries.
CONTROL WITHOUT THE FRICTION

Enterprise features for every modern stack.

Designed for organizations that require strict security, compliance oversight, and high developer productivity.

Permission-gated SQL

Every SQL statement is parsed with Microsoft ScriptDom in memory and validated against effective permissions before transmission.

Granular object scoping

Control access at database, schema, table, and view levels with role-specific whitelists and blacklists.

Dynamic data masking

In-flight redaction protects card numbers, emails, and medical identifiers for HIPAA, GDPR, and PCI-DSS compliance.

Visual explain plans

Inspect query execution plans, operator tree hierarchies, and node costs to identify bottlenecks before execution.

Multi-format export

Export results directly to CSV, Excel (.xlsx, .xlsb), JSON, Markdown, or runnable SQL INSERT scripts.

Access on your terms

Manage role and user grants, review access approval requests, and enforce temporary expiring access windows.

Accountability built in

Fail-closed architecture guarantees a persistent audit row write before any statement reaches the database engine.

Monaco SQL workspace

Explore database objects, write queries with autocomplete, and manage multiple query tabs in one unified interface.

Passkeys and 2FA

Sign in with WebAuthn passkeys or TOTP authenticator apps for modern, phishing-resistant security.

GET STARTED

Deploy Query Gate anywhere.

Query Gate runs wherever .NET 10 and PostgreSQL are supported. Pick a deployment target below to view setup instructions.

SECURITY AND SCOPE

Guardrails with least privilege.

Application-level permissions complement native database permissions. Use dedicated least-privilege accounts, enforced TLS, and protected connection strings.

Capabilities and guardrails:
  • Runs on .NET 10 and PostgreSQL. Supports PostgreSQL, SQL Server, MySQL, and MariaDB targets.
  • Granular object-level scoping and role inclusion/exclusion boundaries.
  • Dynamic PII data masking (HIPAA, GDPR, PCI-DSS, SOC 2).
  • Multi-format exports: CSV, Excel (.xlsx, .xlsb), JSON, Markdown, and SQL INSERT.
  • Fail-closed audit-first query pipeline and Monaco editor workspace.
Read deployment and security guidance

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.