Database Schema Designer
Skill Verifiziert AktivUse when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.
Design robust and efficient database schemas, automate migration processes, and generate necessary code artifacts from requirements.
Funktionen
- Database schema design from requirements
- Automated migration script generation (Drizzle, Prisma, TypeORM, Alembic)
- TypeScript and Python type generation
- Row-Level Security (RLS) policy design
- Index strategy optimization
- Seed data generation
- ERD diagram generation (Mermaid)
Anwendungsfälle
- Designing a new feature that requires database tables
- Reviewing and normalizing existing database schemas
- Implementing multi-tenancy or audit trails
- Generating code types from schema definitions
- Planning and executing database schema migrations
Nicht-Ziele
- Directly executing SQL migrations on a live database
- Acting as a full-fledged database administration tool
- Designing NoSQL or graph database schemas
Installation
Zuerst Marketplace hinzufügen
/plugin marketplace add alirezarezvani/claude-skills/plugin install engineering@claude-code-skillsQualitätspunktzahl
VerifiziertVertrauenssignale
Ähnliche Erweiterungen
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.
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.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Azure Postgres Ts
100Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
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.