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 3,841–3,864 of 4,314 skills

Dbt Migration ValidationADefine and enforce validation rules for dbt models during migration. This skill provides comprehensive validation rules, common anti-patterns to detect, and auto-fix suggestions that are implemented by the validation hooks.databasespythongoVotes: 0GitHub stars: 666
Dbt Migration PostgresATransform PostgreSQL/Greenplum/Netezza DDL (views, tables, stored procedures) into production-quality dbt models compatible with Snowflake, maintaining the same business logic and data transformation steps while following dbt best practices.databasessqlexpressVotes: 0GitHub stars: 666
Dbf Data AnalysisAThis skill should be used when the user asks to "analyze DBF files", "read DBF data", "query DBF database", "convert DBF to Parquet", "analyze Thai accounting data", "explore legacy database", "run DuckDB queries on DBF", or mentions DBF, Parquet conversion, or Thai legacy accounting systems. Provides comprehensive guidance for reading, converting, and analyzing Thai legacy DBF accounting databases.databasespythonbashVotes: 0GitHub stars: 666
Dbcli TablesAList all tables in a database and show table structure (columns, types, constraints) for 30+ databases using DbCli. Use when user wants to explore database schema, see what tables exist, check table structure, or understand column definitions.databasesjavascriptpythonVotes: 0GitHub stars: 666
Dbcli QueryAExecute SELECT queries on 30+ databases (SQLite, SQL Server, MySQL, PostgreSQL, Oracle, etc.) using DbCli. Returns data in JSON, table, or CSV format. Use when user needs to query databases, read data, or execute SELECT statements.databasesjavascriptpythonVotes: 0GitHub stars: 666
Dbcli InteractiveAInteractive SQL mode for 30+ databases using DbCli. Provides REPL environment for exploratory queries, rapid prototyping, and database administration. Includes safety prompts before dangerous operations (UPDATE/DELETE/DROP). Use when user wants interactive database session.databasesrustgoVotes: 0GitHub stars: 666
Dbcli ExportAExport table data as SQL INSERT statements from 30+ databases using DbCli. Essential for creating backups before dangerous modifications (UPDATE/DELETE/DROP). Use when user needs to backup data, migrate tables, or create portable SQL dumps.databasespythonrustVotes: 0GitHub stars: 666
Dbcli ExecAExecute INSERT, UPDATE, DELETE statements on 30+ databases using DbCli. Includes mandatory backup procedures before destructive operations. Use when user needs to modify data, insert records, update fields, or delete rows. Always create backups first.databasespythonrustVotes: 0GitHub stars: 666
Dbcli Db DdlAExecute DDL (Data Definition Language) statements - CREATE, ALTER, DROP tables, indexes, views on 30+ databases using DbCli. CRITICAL - requires mandatory backup before DROP/ALTER operations. Use when user needs to create schema, modify structure, or drop database objects.databasesrustgoVotes: 0GitHub stars: 666
Dbc SchemaAGenerate Effect Schema definitions for WoW DBC tables. Use when adding new game data tables or updating existing schemas.databasesapidatabaseVotes: 0GitHub stars: 666
DbAGère le schéma Prisma et les migrations de Motivia. Utilise ce skill quand l'utilisateur demande de modifier la base de données, ajouter une table, un champ, une relation, ou effectuer une migration. PostgreSQL avec Prisma ORM.databasesgobashVotes: 0GitHub stars: 666
Db WorkflowADatabase migration workflow helper. Use when creating database migrations, modifying SQLAlchemy models, or managing Alembic migrations. Automatically handles model changes, migration creation, and database upgrades.databasesbashsqlVotes: 0GitHub stars: 666
Db Wal RecoveryAGuide for recovering data from SQLite Write-Ahead Log (WAL) files that may be corrupted, encrypted, or inaccessible through standard methods. This skill should be used when tasks involve SQLite database recovery, WAL file analysis, encrypted database files, or discrepancies between tool outputs and filesystem access.databasesgobashVotes: 0GitHub stars: 666
Db ValidateAValidate Laravel database configuration and test actual connections. Use when user reports "database connection error", "hosts array is empty", "could not connect to database", or wants to verify database setup is correct.databasesphpbashVotes: 0GitHub stars: 666
Db SqliteASQLite database management with Prisma ORM, type-safe queries, and Railway deployment with Litestream backup. This skill should be used when creating database schemas, writing migrations, managing SQLite on Railway volumes, or troubleshooting database issues.databasestypescriptshellVotes: 0GitHub stars: 666
Db Schema ManagerAManages all database table schemas for the AI Trading System. Use when: creating tables, validating data before insert/update, checking schema compatibility, generating migrations, or when user mentions database schema, table structure, column definitions, data validation, or schema mismatch.databasespythonbashVotes: 0GitHub stars: 666
Db Schema ChangeAHandle Drizzle database schema changes safely. Generate and apply migrations, add tables and columns. Use when modifying database schema, adding tables, creating migrations, or making database changes.databasestypescriptbashVotes: 0GitHub stars: 666
Db QueryAデータベースクエリ・分析支援。SQLクエリの作成、実行、結果の分析を行う。BigQuery、PostgreSQL、MySQL対応。トリガー: /db-query, SQL, クエリ, データ分析, BigQuerydatabasesbashsqlVotes: 0GitHub stars: 666
Db Query OptimizationAComprehensive guide to optimizing database queries, understanding EXPLAIN plans, indexing strategies, and eliminating N+1 queriesdatabasesjavascriptpythonVotes: 0GitHub stars: 666
Db PostgresAPostgreSQL database management with Drizzle ORM, versioned migrations, and type-safe queries. This skill should be used when setting up a new database, writing migrations, managing schemas, or troubleshooting database issues in PostgreSQL projects.databasestypescriptbashVotes: 0GitHub stars: 666
Db Performance WatchlistADefines database performance monitoring strategy with slow query detection, resource usage alerts, query execution thresholds, and automated alerting. Use for "database monitoring", "performance alerts", "slow queries", or "DB metrics".databasestypescriptsqlVotes: 0GitHub stars: 666
Db Performance Watchlist Monkey1sai Openai CliADefines database performance monitoring strategy with slow query detection, resource usage alerts, query execution thresholds, and automated alerting. Use for "database monitoring", "performance alerts", "slow queries", or "DB metrics".databasestypescriptsqlVotes: 0GitHub stars: 666
Db Performance PatternsAPatterns for optimizing database queries and preventing connection pool exhaustion. Use when writing batch operations, debugging slow queries, or reviewing code for performance.databasestypescriptgoVotes: 0GitHub stars: 666
Db OperationsAPostgreSQL database operations specialist using Drizzle ORM for schema management, queries, and migrationsdatabasestypescriptbashVotes: 0GitHub stars: 666