Database Design & Operations Audit

Evaluates database schema design, query patterns, migration safety, access control, backup strategy, and operational monitoring for SQL databases.

This audit covers 28 checks across schema design (primary keys, foreign keys, indexes, constraints, types, naming), query patterns (N+1 prevention, parameterized queries, connection pooling, transactions), migration safety (tooling, non-destructive changes, rollback, version control), security (credentials, RLS, least privilege, encryption, SSL), backup & recovery (strategy, PITR, restore procedures, credential rotation), and monitoring (health checks, slow queries, connection monitoring). Supports PostgreSQL, MySQL, SQLite, and ORMs including Prisma, Drizzle, Knex, TypeORM, and Sequelize.

Changelog