Two plugins for safer SQL in DataGrip: production-aware query review and migration checks
Hi! I build two plugins that might help DataGrip users who work on production databases:
- QueryGuard — classifies data sources (DEV/TEST/STAGING/PROD, also via a shared `.queryguard.yml`) and
reviews `DELETE`/`UPDATE` without `WHERE`, `DROP`, `TRUNCATE` and data-modifying CTEs before you run them.
https://plugins.jetbrains.com/plugin/34131-queryguard
- MigrationGuard — reviews migration files (Flyway, Liquibase formatted SQL) for data loss, locking and
rolling-deploy risks; free GitHub Action for pull requests.
https://plugins.jetbrains.com/plugin/34107-migrationguard
Both run locally and send no SQL anywhere. Bug reports and ideas:
https://github.com/jog16889/technofystore-support
Please sign in to leave a comment.