Audit database schemas for redundant indexes, missing foreign keys, and migration safety.
npx skills add https://github.com/hamzaPixl/pixl-ai --skill schema-audit
Please help me install this Agent Skill. Skill: schema-audit Source: https://github.com/hamzaPixl/pixl-ai/tree/main/packages/crew/skills/schema-audit Command: npx skills add https://github.com/hamzaPixl/pixl-ai --skill schema-audit
Developers and DBAs often miss hidden issues in database schemas such as redundant indexes, missing foreign keys, naming inconsistencies, N+1 query risks, and unsafe migrations, leading to performance degradation and data integrity problems.
Run the schema-audit skill on the project’s database schema directory to receive a detailed audit report.
High-intent search queries and answers about installing and using this skill.
To audit database schema for redundant indexes and missing foreign keys, run a schema audit on your schema directory to generate a prioritized scorecard with severity ratings and remediation suggestions.
Yes, you can detect N+1 query risks in Prisma or SQLAlchemy schemas by analyzing eager-loading gaps and query patterns that cause N+1 problems, receiving a detailed risk report.
Check database migration safety by auditing migration history to flag dangerous operations, missing rollbacks, and data-integrity risks before deployment, ensuring safe schema evolution.
Yes, the schema audit works with raw SQL and SQLite schemas, auto-detecting schema files and migration history to analyze constraints, indexes, and naming conventions.
Enforce consistent table and column naming conventions by running a naming audit that detects inconsistencies across your schema files and provides remediation guidance.
Your database schema audit report shows missing NOT NULL constraints because the constraint audit detects absent NOT NULL declarations, uniqueness gaps, and missing foreign keys, highlighting data integrity vulnerabilities.
autorundevAutomate database migrations for Python applications using Alembic and raw SQL.
infraspecdevReview database code for schema design, migration safety, ORM correctness, and query performance risks.
Mischio95Diagnose and optimize Prisma ORM schema, migrations, and query performance.
paultyngReview PostgreSQL and MySQL migrations, queries, and schema designs.
