Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,708
pages available: 197

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 4,561–4,584 of 4,708 skills

Projection PatternsABuild read models and projections from event streams. Use when implementing CQRS read sides, building materialized views, or optimizing query performance in event-sourced systems.databasespythongoVotes: 0GitHub stars: 416
Event Store DesignADesign and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.databasespythongoVotes: 0GitHub stars: 416
Database FundamentalsAAuto-invoke when reviewing schema design, database queries, ORM usage, or migrations. Enforces normalization, indexing awareness, query optimization, and migration safety.databasestypescriptgoVotes: 0GitHub stars: 416
Schema VisualizerAGenerate database schema diagrams, ERDs, and documentation from database schemas.databasestypescriptpythonVotes: 0GitHub stars: 416
Query OptimizerAAnalyze and optimize SQL queries for better performance and efficiency.databasesjavascriptgoVotes: 0GitHub stars: 416
Migration GeneratorACreate database migrations from model changes, schema diffs, and migration best practices.databasestypescriptpythonVotes: 0GitHub stars: 416
Database OperationsAInstructions on how to write database queries with SQLAlchemy.databasessqldatabaseVotes: 0GitHub stars: 416
Check MigrationAFlywayマイグレーションチェックスキル - マイグレーションファイルの検証、バージョン番号の競合チェック、命名規則チェック、SQL構文チェックを実施します。mainブランチとの競合確認も行い、マイグレーションの品質を保証します。databasesbashsqlVotes: 0GitHub stars: 416
Database MigrationAGuide for creating idempotent Supabase database migrations with RLS policies and workspace isolationdatabasesbashsqlVotes: 0GitHub stars: 416
Py Sqlmodel PatternsASQLModel and async SQLAlchemy patterns. Use when working with database models, queries, relationships, or debugging ORM issues.databasespythongoVotes: 0GitHub stars: 416
Postgres PerformanceAHigh-performance PostgreSQL patterns. Use when optimizing queries, designing for scale, or debugging performance issues.databasespythonsqlVotes: 0GitHub stars: 416
Postgres PatternsAPostgreSQL patterns for reviewing migrations and writing efficient queries. Use when reviewing Alembic migrations, optimizing queries, or debugging database issues.databasespythongoVotes: 0GitHub stars: 416
Sqlite OpsAPatterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.databasespythongoVotes: 0GitHub stars: 416
Sql PatternsAQuick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strategy, pagination sql.databasessqlexpressVotes: 0GitHub stars: 416
Python Database PatternsASQLAlchemy and database patterns for Python. Triggers on: sqlalchemy, database, orm, migration, alembic, async database, connection pool, repository pattern, unit of work.databasespythonbashVotes: 0GitHub stars: 416
Database Backup AutomatorAUse when you need to automate database backup processes with scheduling and encryption. This skill creates backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite with compression. Trigger with phrases like "automate database backups", "schedule database dumps", "create backup scripts", or "implement disaster recovery for database".databasesgoshellVotes: 0GitHub stars: 21
Database Audit LoggerAUse when you need to track database changes for compliance and security monitoring. This skill implements audit logging using triggers, application-level logging, CDC, or native logs. Trigger with phrases like "implement database audit logging", "add audit trails", "track database changes", or "monitor database activity for compliance".databasesbashsqlVotes: 0GitHub stars: 21
Database Archival SystemAUse when you need to archive historical database records to reduce primary database size. This skill automates moving old data to archive tables or cold storage (S3, Azure Blob, GCS). Trigger with phrases like "archive old database records", "implement data retention policy", "move historical data to cold storage", or "reduce database size with archival".databasesshellbashVotes: 0GitHub stars: 21
Data Validation EngineAUse when you need to ensure database integrity through comprehensive data validation. This skill validates data types, ranges, formats, referential integrity, and business rules. Trigger with phrases like "validate database data", "implement data validation rules", "enforce data integrity constraints", or "validate data formats".databasesbashsqlVotes: 0GitHub stars: 21
Data Seeder GeneratorAThis skill enables claude to generate realistic test data and databasedatabasesjavascriptjavaVotes: 0GitHub stars: 21
Database Test ManagerAThis skill manages database testing by generating test data, wrapping tests in transactions, and validating database schemas. It is used to create robust and reliable database interactions. Claude uses this skill when the user requests database testing utilities, including test data generation, transaction management, schema validation, or migration testing. Trigger this skill by mentioning "database testing," "test data factories," "transaction rollback," "schema validation," or using the `/...databasespythonsqlVotes: 0GitHub stars: 21
Stored Procedure GeneratorAThis skill uses the stored-procedure-generator plugin to create production-ready stored procedures, functions, triggers, and custom database logic. It supports PostgreSQL, MySQL, and SQL Server. Use this skill when the user asks to "generate stored procedure", "create database function", "write a trigger", or needs help with "database logic", "optimizing database performance", or "ensuring transaction safety" in their database. The skill is activated by requests related to database stored pro...databasessqldatabaseVotes: 0GitHub stars: 21
Sql Query OptimizerAThis skill analyzes and optimizes SQL queries for improved performance. It identifies potential bottlenecks, suggests optimal indexes, and proposes query rewrites. Use this when the user mentions "optimize SQL query", "improve SQL performance", "SQL query optimization", "slow SQL query", or asks for help with "SQL indexing". The skill helps enhance database efficiency by analyzing query structure, recommending indexes, and reviewing execution plans.databasesgosqlVotes: 0GitHub stars: 21
Sql ProAMaster modern SQL with cloud-native databases, OLTP/OLAPdatabasesgosqlVotes: 0GitHub stars: 45,825