Databases

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

skills in category: 4,314
pages available: 180

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,177–4,200 of 4,314 skills

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
PostgresqlADesign a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced featuresdatabasesgosqlVotes: 0GitHub stars: 45,825
Database OptimizerAExpert database optimizer specializing in modern performancedatabasesgosqlVotes: 0GitHub stars: 45,825
Database Migrations Sql MigrationsASQL database migrations with zero-downtime strategies fordatabasesgobashVotes: 0GitHub stars: 45,825
Text To SqlAConvert natural language queries to SQL. Use for database queries, data analysis, and reporting.databasesbashsqlVotes: 0GitHub stars: 40
Uspto DatabaseAAccess USPTO APIs for patent/trademark searches, examination history (PEDS), assignments, citations, office actions, TSDR, for IP analysis and prior art searches.databasespythongoVotes: 0GitHub stars: 40
Nosql ExpertAExpert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.databasesgosqlVotes: 0GitHub stars: 30,495
Neon PostgresAExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.databasesdatabaseVotes: 0GitHub stars: 30,495
Gnomad FrequenciesAQuery gnomAD for population allele frequencies to assess variant rarity. Use when filtering variants by population frequency for rare disease analysis or determining if a variant is common in the general population.databasespythongoVotes: 0GitHub stars: 1,198
Molecular IoAReads, writes, and converts molecular file formats (SMILES, SDF, MOL2, PDB) using RDKit and Open Babel. Handles structure parsing, canonicalization, and full standardization pipeline including sanitization, normalization, and tautomer canonicalization. Use when loading chemical libraries, converting formats, or preparing molecules for analysis.databasespythondatabaseVotes: 0GitHub stars: 1,198