Db Check
Skill Verifiziert AktivValidate database schema integrity and check for common issues
Validate database schema integrity and identify common issues within a project's ORM models and raw SQL queries.
Funktionen
- ORM schema analysis
- Database table integrity checks
- Index validation
- N+1 query pattern detection
- SQL injection vulnerability scanning
Anwendungsfälle
- Ensuring database tables are correctly modeled by the ORM.
- Optimizing database performance by checking for missing indexes.
- Preventing SQL injection vulnerabilities in raw queries.
- Verifying referential integrity and migration history.
Nicht-Ziele
- Performing database migrations.
- Directly modifying database structures.
- Replacing a full database administration tool.
Workflow
- Read ORM schema file and analyze all models.
- Check for unmodeled database tables.
- Verify indexes on foreign keys and frequently queried columns.
- Scan for N+1 query patterns.
- Check raw SQL queries for injection vulnerabilities.
- Verify referential integrity and date handling.
- Review migration history for risky operations.
- Report findings with severity levels (CRITICAL/HIGH/MEDIUM/LOW).
Praktiken
- Database integrity
- Code quality
- Security scanning
Voraussetzungen
- Access to the project's ORM schema files (e.g., Prisma, Drizzle).
- Access to raw SQL query files or context.
- A Claude Code environment capable of analyzing code.
Install
- info:Installation instructionInstallation instructions are part of a larger blueprint setup, not specific to this single skill, and lack a direct invocation example for this skill.
Practical Utility
- info:Usage examplesWhile the README and SKILL.md describe the skill's capabilities, specific, ready-to-run examples for this particular skill are not provided.
Installation
npx skills add faizkhairi/claude-code-blueprintFührt das Vercel skills CLI (skills.sh) via npx aus — benötigt Node.js lokal und mindestens einen installierten skills-kompatiblen Agent (Claude Code, Cursor, Codex, …). Setzt voraus, dass das Repo dem agentskills.io-Format folgt.
Qualitätspunktzahl
VerifiziertVertrauenssignale
Ähnliche Erweiterungen
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
DBHub Database Query Guide
100Anleitung zum Abfragen von Datenbanken über den DBHub MCP-Server. Verwenden Sie diese Fähigkeit immer dann, wenn Sie Datenbankschemata untersuchen, Tabellen inspizieren oder SQL-Abfragen über die MCP-Tools von DBHub ausführen müssen (search_objects, execute_sql). Aktiviert bei jeder Datenbankabfrageaufgabe, Schemadeckung, Datenabfrage oder SQL-Ausführung über MCP – auch wenn der Benutzer nur „Datenbank prüfen“ oder „mir Daten finden“ sagt. Diese Fähigkeit stellt sicher, dass Sie dem richtigen Workflow „zuerst erkunden“ folgen, anstatt Tabellenstrukturen zu erraten.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Database Patterns
98Database design patterns including schema design, migrations, soft deletes, and Exposed ORM. Use when creating tables, writing migrations, or implementing repositories.