QueryGuard
EN ES
Get QueryGuard
For JetBrains DataGrip · PostgreSQL

Catch destructive SQL
before it ever runs.

QueryGuard is the final safety review for DataGrip. It flags DELETE and UPDATE without WHERE, plus DROP, TRUNCATE and risky transactions — analyzed entirely inside your IDE.

Install from Marketplace See how it works
100% local analysis
No SQL or credentials leave your IDE
Zero telemetry
cleanup.sql
prod-db · Production
1
2
3
4
-- monthly cleanup routine
DELETE FROM orders;
 
-- ⚠ no WHERE clause
QueryGuard · Safety Check
2 findings
DELETE without WHERERISK 9.2 · HIGH

Statement affects every row in orders. Production datasource — execution blocked pending confirmation.

Cancel Add WHERE clause
Analyzed locally
in 14 ms · nothing sent
Built for the JetBrains database stack DataGrip 2025.3+ PostgreSQL Validated 2025.3 & 2026.2
Capabilities

A final review that never leaves your machine.

Every safeguard runs inside DataGrip. No proxy, no cloud service, no account — just a disciplined check between you and an irreversible statement.

Destructive-query detection

Flags DELETE/UPDATE without WHERE, DROP, TRUNCATE, multi-statement risk and loose key predicates.

Environment awareness

Classify each datasource as production, staging or dev. Unclassified connections are never reported as safe.

Shared team policies

Commit a .queryguard.yml at the project root. Version-controlled rules everyone on the team inherits.

Local audit trail

Sanitized metadata only — time, datasource alias, environment, score, rule IDs and action. Never the SQL itself.

Zero data egress

No SQL, results, credentials or connection strings are ever uploaded. Free analysis works fully offline.

Right in your flow

Run Check Query Safety straight from the SQL editor menu — no context switch, no extra window.

Privacy by architecture

Privacy isn't a setting.
It's the architecture.

QueryGuard analyzes SQL inside your IDE and stops there. It does not collect, transmit, sell or share your queries, results, credentials, schema or telemetry — because none of it is ever sent in the first place.

Works completely offline
No account, no login, no tracking
Audit records are sanitized metadata only
.queryguard.yml
# team safety policy
datasources:
  prod-db: production
  staging-db: staging
rules:
  delete_without_where: block
  truncate: block
telemetry: never
Pricing

Start free. Upgrade when your team does.

Local warnings and Check Query Safety are free forever. Pro adds shared policies, reinforced confirmations and audit export.

Free
$0forever

Everything you need for personal safety checks.

Local destructive-query warnings
Manual Check Query Safety
Datasource classification
Fully offline analysis
Install free
Most popular Pro · Individual
$49/ year

For developers who touch production. 30-day trial.

Everything in Free
Shared .queryguard.yml policies
Reinforced confirmations
Advanced rules & audit export
Start 30-day trial
Pro · Team
$99/ year

The full Pro feature set, for team purchasing.

Every Pro capability
Centralized team licensing
Consistent policy across the org
Priority support
Talk to us

Paid plans activate after JetBrains Marketplace approves the product code. Until then, everything runs free.

Ship changes with confidence.

Put a disciplined, private safety review between your team and the queries you can't undo.

Install from JetBrains Marketplace Read the docs