query-compliance

What problem does it solve?

It prevents insecure and slow database access by standardizing how teams write queries, migrations, and schema changes for MongoDB and SQL databases.

Core Features & Use Cases

• Secure Query Practices: Avoids SQL raw with string interpolation by using parameterized queries, enforces least-privilege database users, and prohibits hardcoded credentials.
• Performance-Focused Design: Encourages proper indexing for WHERE/JOIN/ORDER BY patterns, flags anti-patterns like SELECT *, addresses N+1 queries, and uses pagination plus EXPLAIN/EXPLAIN ANALYZE for slow queries.
• Migration-Safe Schema Management: Requires reversible migrations (up/down), blocks risky production column changes without staging-tested migrations, and specifies explicit foreign key ON DELETE behavior with consistent timestamps and soft-delete conventions.

Quick Start

Ask the AI to review your proposed MongoDB or SQL query and migration plan against secure query compliance, indexing, pagination, and reversibility rules.