sql-architect

What problem does it solve?

Database design governance: standardizes SQL practices to reduce defects and improve maintainability across schemas.

Core Features & Use Cases

• Schema design rules: primary keys, foreign keys, NOT NULL, CHECK constraints, audit columns, soft delete.
• Naming conventions: tables, columns, FKs, indexes, constraints, sequences.
• Indexing strategy: index all FK columns, use appropriate index types, partial indexes for soft-deletes.
• Query patterns: parameter binding, explicit column lists, RETURNING, upserts, cursor-based pagination, CTEs.
• Migrations & security: forward-only migrations, role-based access, RLS; security guidelines.
• Performance & JSON: EXPLAIN ANALYZE, performance tuning, JSON guidance.
• Engine-specific notes: PostgreSQL 18 primary; MySQL 9 and SQLite 3.53 notes.

Quick Start

Initialize your project with UUID v7 primary keys, NOT NULL and CHECK constraints, soft delete via deleted_at, and forward-only migrations to enforce a scalable schema.