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 289–312 of 4,314 skills

Outbox Pattern ImplementationAUse when you need to publish a message to Kafka / RabbitMQ / SNS atomically with a database commit, when fixing the dual-write hazard between DB and broker, deciding between polling-publisher and CDC (Debezium) relay, designing the outbox schema, handling at-least-once / idempotency on the consumer, or pruning a high-volume outbox table. Triggers: dual write, "we updated the DB but the event never published", outbox/inbox pattern, Debezium connector, EventRouter SMT, aggregate_type / aggregat...databasesrustgoVotes: 0GitHub stars: 2
Multi Agent CoordinationACoordinate multiple AI agents working on the same codebase or project simultaneously. Covers git worktree isolation, file locking strategies, message passing between agents, shared state management, conflict resolution, task decomposition for parallel agents, and patterns from Claude Code, Cursor, Devin, and similar multi-agent developer tools. Activate on: "multi-agent", "parallel agents", "agent coordination", "worktree isolation", "concurrent agents", "file locking agents", "agent conflict...databasesgobashVotes: 0GitHub stars: 2
Duckdb AnalyticsAUse when running analytical SQL over Parquet/CSV/JSON without a warehouse, replacing pandas for data wrangling, joining S3 data in-place, building local data marts, or embedding OLAP into an app. Triggers: read_parquet/read_csv setup, partitioned dataset queries, hive partitioning, glob patterns for S3, COPY TO export, attach Postgres/MySQL, UDFs in Python/R, MotherDuck cloud sync, columnar performance vs row stores. NOT for OLTP workloads (concurrent writes), distributed analytics at petabyt...databasespythongoVotes: 0GitHub stars: 2
Distributed Tracing W3c ContextAImplementing distributed tracing with W3C Trace Context — the byte-precise `traceparent` and `tracestate` header formats, OpenTelemetry's W3CTraceContextPropagator as the modern default (replacing X-B3-* and X-Datadog-*), head vs tail sampling, and HTTP→SQL trace propagation via sqlcommenter. Grounded in the W3C REC and OpenTelemetry specs. NOT for OTel metrics/logs pipelines, vendor backend setup (Datadog/Honeycomb/Jaeger/Tempo), or browser RUM tracing.databasesgobashVotes: 0GitHub stars: 2
Db Retention And CompactionADesigns and audits data retention and file compaction for an embedded SQLite datastore in a long-lived service — a unified retention registry (one declared policy per table), TTL / absolute-age / row-count-cap policies, a fail-loud coverage guard, WAL/checkpoint tuning, and auto_vacuum/incremental-vacuum so pruning actually shrinks the file. Use when a SQLite DB grows unbounded, a table has an index but no DELETE, a pruned DB never shrinks on disk, metrics are stored as raw events forever, or...databasespythongoVotes: 0GitHub stars: 2
D1 And Supabase MigrationsAUse when applying Cloudflare D1 migrations, fighting Supabase migration history vs SQL execution, choosing direct psql over CLI, designing idempotent migrations, debugging schema drift between local and remote, or recovering after a half-applied migration. Triggers: supabase migration repair instructions appearing, table missing after "applied" status, "Tenant or user not found" when running psql, --remote vs --local D1 confusion, NOT NULL on a populated column, foreign key constraint failure...databasesrustgoVotes: 0GitHub stars: 2
VaultBExpert agent for HashiCorp Vault across all editions (Community, Enterprise, HCP). Covers seal/unseal, secret engines (KV, database, PKI, transit), auth methods (AppRole, Kubernetes, OIDC, AWS), policies, Vault Agent, Vault Secrets Operator, and replication. WHEN: \"HashiCorp Vault\", \"Vault seal\", \"Vault unseal\", \"secret engine\", \"AppRole\", \"Vault Agent\", \"Vault Operator\", \"VSO\", \"transit encryption\", \"Vault PKI\".databasesrustgoVotes: 0GitHub stars: 4
RhelBRed Hat Enterprise Linux across all supported versions (8, 9, 10): systemd, dnf/rpm, Application Streams, firewalld, NetworkManager, storage (LVM, XFS, Stratis), subscription management, Cockpit, SELinux basics, crypto policies, audit, and performance tuning. Use when: \"RHEL\", \"Red Hat\", \"Red Hat Enterprise Linux\", \"dnf\", \"systemd\", \"subscription-manager\", \"Application Streams\", \"firewalld\", \"tuned\", \"SELinux\", \"rpm-ostree\", \"bootc\", \"Cockpit\", \"nmcli\", \"journalct...databasesrustgoVotes: 0GitHub stars: 4
PowerdnsBExpert coverage of the PowerDNS suite (Authoritative Server 5.0, Recursor 5.4, and DNSdist 2.0): pluggable backends (MySQL/PostgreSQL/LDAP), DNSSEC auto-signing, REST API, Lua scripting, views, RPZ threat blocking, YAML configuration, DoH/DoT termination, and DNS load balancing. Use for \"PowerDNS\", \"pdns\", \"pdnsutil\", \"Recursor\", \"DNSdist\", \"PowerDNS API\", \"PowerDNS backend\", \"PowerDNS DNSSEC\". Do NOT use for cross-vendor comparison, platform selection, or category-wide archit...databasesrustgoVotes: 0GitHub stars: 4
TimescaledbATimescaleDB technology expert covering ALL versions. Deep expertise in hypertables, continuous aggregates, compression, data retention, and time-series query optimization built on PostgreSQL. WHEN: \"TimescaleDB\", \"timescale\", \"hypertable\", \"continuous aggregate\", \"chunk\", \"compression timescale\", \"cagg\", \"time_bucket\", \"add_compression_policy\", \"add_retention_policy\", \"Timescale Cloud\", \"Tiger Cloud\", \"TigerData\", \"tsdb\", \"timescaledb_information\", \"hyperfunctio...databasesgosqlVotes: 0GitHub stars: 4
SqliteASQLite technology expert. Deep expertise in embedded database design, WAL mode, FTS5, JSON support, window functions, virtual tables, and application integration. WHEN: \"SQLite\", \"sqlite3\", \".sqlite\", \"WAL mode\", \"FTS5\", \"PRAGMA\", \"sqlite3_\", \"ATTACH DATABASE\", \"virtual table\", \"SQLite JSON\", \"STRICT tables\", \"SQLite WASM\", \"litestream\", \"rqlite\".databasesgosqlVotes: 0GitHub stars: 4
PostgresqlAPostgreSQL technology expert covering ALL versions. Deep expertise in MVCC, VACUUM, WAL, replication, extensions, query optimization, and operational tuning. WHEN: \"PostgreSQL\", \"Postgres\", \"psql\", \"pg_stat\", \"VACUUM\", \"MVCC\", \"WAL\", \"pgAdmin\", \"pg_dump\", \"autovacuum\", \"PgBouncer\", \"PostGIS\", \"pgvector\", \"pg_cron\", \"JSONB\", \"EXPLAIN ANALYZE\", \"shared_buffers\", \"work_mem\", \"streaming replication\", \"logical replication\", \"TOAST\", \"pg_basebackup\".databasessqlapiVotes: 0GitHub stars: 4
OverviewACross-engine database expertise for architecture selection, data modeling, and database comparison across all paradigms (RDBMS, document, key-value, wide-column, graph, time-series, search, columnar/OLAP, cloud warehouses, embedded). Use when the question is technology-agnostic: \"which database\", \"database architecture\", \"SQL vs NoSQL\", \"database comparison\", \"choose a database\", \"data modeling\", \"ACID vs BASE\", \"CAP theorem\", \"database paradigm\", \"relational vs document\",...databasesgoc++Votes: 0GitHub stars: 4
OracleAOracle Database technology expert covering architecture, administration, diagnostics, and PL/SQL development. WHEN to trigger: "Oracle Database", "Oracle DB", "PL/SQL", "ORA-", "AWR", "ASH", "ADDM", "RAC", "Data Guard", "RMAN", "tablespace", "SGA", "PGA", "CDB", "PDB", "multitenant", "ASM", "V$SESSION", "DBA_", "GV$", "listener", "tnsnames", "sqlplus", "SQL*Plus"databasesgojavaVotes: 0GitHub stars: 4
MariadbAMariaDB technology expert covering ALL versions. Deep expertise in InnoDB, Aria, ColumnStore, Galera Cluster, MaxScale, replication, query optimization, and operational tuning. WHEN: \"MariaDB\", \"Galera\", \"MaxScale\", \"ColumnStore\", \"Aria engine\", \"mariadb-dump\", \"MariaDB replication\", \"mariadb-backup\", \"Spider engine\", \"WSREP\", \"Galera cluster\", \"mariadb.cnf\", \"mariadb-secure-installation\", \"system versioning\", \"MariaDB thread pool\".databasessqlnodeVotes: 0GitHub stars: 4
CosmosdbAAzure Cosmos DB expert. Deep expertise in multi-model APIs (NoSQL, MongoDB, Cassandra, Gremlin, Table), partitioning, consistency levels, RU optimization, global distribution, and operational tuning. WHEN: \"Cosmos DB\", \"CosmosDB\", \"Cosmos\", \"Request Units\", \"RU/s\", \"partition key Cosmos\", \"consistency level\", \"global distribution\", \"multi-region writes\", \"Cosmos DB NoSQL\", \"Cosmos DB MongoDB\", \"change feed\", \"Cosmos DB serverless\".databasesjavascriptgoVotes: 0GitHub stars: 4
FastapiAExpert skill for FastAPI web framework development. Covers ASGI/Starlette foundation, Pydantic v2 integration, dependency injection, path operations, automatic OpenAPI generation, async/await patterns, middleware, security (OAuth2, JWT), testing (TestClient, httpx), SQLAlchemy/SQLModel integration, and deployment. WHEN: \"FastAPI\", \"Starlette\", \"ASGI\", \"Pydantic\", \"Depends\", \"APIRouter\", \"path operation\", \"response_model\", \"OpenAPI auto-docs\", \"Swagger UI\", \"FastAPI middle...databasespythonrustVotes: 0GitHub stars: 4
Service MapperAAnalyze a codebase to produce a complete service map — microservices, inter-service communication, database ownership, external integrations, and event flows. Generates AI-agent-friendly markdown. Use when onboarding to a new codebase, auditing architecture, updating CLAUDE.md, or before planning new features. Triggers on "map services", "service map", "map the architecture", "what services exist", "how do services communicate", "map this repo", "generate service map", "architecture map".databasestypescriptpythonVotes: 0GitHub stars: 3
Read DbAUse when a task needs real rows, counts, or column facts from a PostgreSQL database — checking data before a migration, debugging one user's stored values, answering "how many / which / is there any" about live data — triggers include "DB 조회", "운영 데이터 확인", "prd에서 확인", "psql", "SELECT", "row count", "NULL 있는지", "query the database". Not for writes, migrations, or schema changes.databasesgobashVotes: 0GitHub stars: 25
Ai LtmA過去の学び・失敗・意思決定・中断点を横断検索し、確定した知見を長期記憶へ記録する。セッション開始・再開、過去の経緯の参照、知見の確定、終了時の要約で自動利用する。短期の判断差分は /field-notes、感想は /ai-diary に分ける。ユーザーが /ai-ltm と入力したら使う。databasessqlapiVotes: 0GitHub stars: 8
Generate Sql DataA通过 GenerateSQL 查询当前登录用户有权访问的企业 MySQL 数据；适用于统计、明细查询、趋势和分类对比。databasessqldatabaseVotes: 0GitHub stars: 45
Legal ResearchA本技能是所有中国法律相关请求的通用研究分析技能和默认兜底技能，可结合法条、司法案例和实务资料完成规则核验、正反观点比较、责任分析、风险评估、路径建议和来源溯引。凡请求涉及法律、法规、司法解释、合同、权利义务、责任、争议、诉讼、仲裁、执行、合规、监管、处罚、维权、案件、证据或法律风险，均属于本技能的触发范围；也覆盖“是否合法”“谁承担责任”“能否主张”“如何维权”“有没有胜算”“下一步怎么处理”等未明确技能名称的表达。用户明确要求法条查询、案例检索、法律文书、法律意见书、企业法律尽职调查、法律尽调报告或案件可视化，且存在能够完整处理该任务或交付物的专用技能时，优先使用专用技能；未明确指定专用技能、没有专用技能命中、专用技能不可用、请求同时跨越多个法律任务，或者法律意图仍有歧义时，必须使用本技能兜底，不得让法律相关请求无技能承接。本技能既可处理复杂中国法律问题、诉讼案件、仲裁争议和合规事项，也可在专用技能未承接时处理单一法条、法规版本、案号、单份裁判文书、类案列表等简单请求，并按问题复杂度缩放研究深度。用户明确指定其他技能或工具时遵从其选择。databasesgoVotes: 0GitHub stars: 45
Vercel StorageAVercel storage expert guidance — Blob, Edge Config, and Marketplace storage (Neon Postgres, Upstash Redis). Use when choosing, configuring, or using data storage with Vercel applications.databasesjavascriptgoVotes: 0GitHub stars: 9
Supabase Postgres Best PracticesAPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.databasesgosqlVotes: 0GitHub stars: 9