Databases skills

6,858 tagged Databases, measured the same way as everything else here.

Browse within: gemini-cli 49ai-skills 47antigravity 46claude-plugin 41data-engineering 38sql 37clickhouse 35embeddings 33claude-code-skills 32codex-cli 32postgresql 32agentic-coding 29open-source 28aws 27

timescale/pg-aiguide

Skill Claude CodeCodex

Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. Trigger when user asks to: Create or design SQL schemas/tables AND…

1.8k +5 yesterday A 219 tokens original Apache-2.0

pubchem-database

74

benchflow-ai/skillsbench

Skill Claude CodeCodex

Query PubChem via PUG-REST API/PubChemPy (110M+ compounds). Search by name/CID/SMILES, retrieve properties, similarity/substructure searches, bioactivity, for cheminformatics.

1.7k +6 1mo ago A 49 tokens original Apache-2.0

dashboard-bootstrap

75

Datus-ai/Datus-agent

Skill Claude CodeCodex

Bootstrap project reference SQL and metrics from a BI dashboard through an installed plugin. Use when the user asks to initialize, import, extract, or build context, reference SQL, semantic models, or metrics from a dashboard or requests dashboard bootstrap.

1.7k +20 yesterday A 50 tokens

extract-knowledge

76

Datus-ai/Datus-agent

Skill Claude CodeCodex

Mine shortest atomic facts from (question + goldsql) pairs into ./knowledge/.md; either by simulating SQL drafting (lite) or by driving the gensql subagent in blind iteration (deep).

1.7k +20 yesterday A 45 tokens

fastcrud

77

benavlabs/fastcrud

Skill Claude CodeCodex

Use when building or modifying CRUD endpoints with FastCRUD (the fastcrud PyPI package) in a FastAPI project — covers FastCRUD, crudrouter, EndpointCreator, FilterConfig, JoinConfig, auto-relationship detection, the filter operator syntax (gte, in, ilike, etc.), cursor pagination, soft delete, and how to avoid N+1…

1.6k +4 2mo ago A 147 tokens original MIT

ktx-analytics

78

Kaelio/ktx

Skill Claude CodeCodex

Use when answering a question that needs data from a ktx-connected database - investigating, analyzing, "how many", "show me", "what's the breakdown of", finding records by value, exploring tables, comparing periods, explaining metrics, or any data-analysis request. Triggers even when the user does not say…

1.6k +3 1mo ago A 86 tokens original Apache-2.0

NPC-Worldwide/npcpy

Skill Claude CodeCodex

Skill for searching and evolving the SQLite-backed Knowledge Graph. Use this when you need structured fact/concept/link search across one or more teams, NPCs, or directory scopes. The Knowledge Graph (KG) is stored in the application's database (not YAML). It is scoped by (teamname, npcname, directorypath). Facts and…

1.5k +4 7d ago A 474 tokens original MIT

alembic-migration

80

fim-ai/fim-one

Skill Claude CodeCodex

Write an Alembic migration for a new ORM model, column, or index. Covers the SQLite/PG dual-track rules, idempotency helpers, the timezone-aware timestamp trap, dialect branching in data migrations, and when to apply. Use whenever a change adds or alters anything in src/fimone/db/models/.

1.5k +6 5d ago A 70 tokens

user-owned-module

81

fim-ai/fim-one

Skill Claude CodeCodex

Wire a new user-owned module into user deletion. Use whenever a change adds a table with a FK to users, or writes files under uploads/ or data/ keyed by user, conversation, or any other per-user id. Covers purgeuserdata(), the file cleanup registry, and the FK-cascade trap.

1.5k +6 5d ago A 66 tokens

Addax

82

wgzhao/Addax

Skill Claude CodeCodex

A reference guide to Addax, an open-source tool for copying data between different databases, files, and other data systems. It explains Addax's jobs, readers, writers, transformations, channels, and task groups.

1.4k yesterday A 0 tokens original Apache-2.0

database-design

83

CloudAI-X/claude-workflow-v2

Skill Claude CodeCodex

Part of claude-workflow-v2

Designs database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases. Use when designing tables, optimizing queries, fixing N+1 problems, planning migrations, or when asked about database performance, normalization, ORMs, or data modeling.

1.4k +2 8d ago A 57 tokens original MIT

HashLoad/horse

Skill Claude CodeCodex

Guide for setting up thread-safe database connection pooling (FireDAC / UniDAC) in multithreaded Horse applications.

1.4k +1 5d ago A 30 tokens original MIT

supabase

85

PentesterFlow/agent

Skill Claude CodeCodex

Supabase / PostgREST Row-Level-Security playbook — pull the anon (or leaked servicerole) key out of the frontend JS, map tables from the auto-generated OpenAPI spec, test anonymous RLS READ disclosures (PII/secret leaks), and anonymous RLS WRITE abuse (insert/update/delete — e.g. forging…

1.3k 2mo ago A 120 tokens original Apache-2.0

analyze-db-logs

86

matthiasn/lotti

Skill Claude CodeCodex

Analyze Drift / SQLite slow-query and super-slow-query logs against this app's known stall patterns (read waves, N+1, transaction scoping, MultiExecutor contention, WAL/OS factors).

1.2k 3d ago A 46 tokens GPL-3.0

boutique-store

87

mergesort/Boutique

Skill Claude CodeCodex

Part of boutique

Create and use Boutique Store for Swift data persistence, including initialization, @Stored controllers, CRUD operations, operation chaining, and granular event monitoring. Use when persisting arrays of items, building data controllers, or working with Boutique's Store type.

1.1k 1mo ago A 52 tokens original MIT

mergesort/Boutique

Skill Claude CodeCodex

Part of boutique

Persist individual values with Boutique's @StoredValue (UserDefaults) and @SecurelyStoredValue (Keychain), including set, reset, toggle, bindings, keypath setters, array and dictionary helpers, and async observation. Use when storing preferences, settings, feature flags, or sensitive data like auth tokens.

1.1k 1mo ago A 68 tokens original MIT

PostHog/posthog.com

Skill Claude CodeCodex

Shared foundations for building reusable data models in PostHog, on either of two stacks: PostHog-native data-warehouse views / materialized views (HogQL, via the view- MCP tools), or an external dbt project (sources.yml + staging/marts + schema tests) run against your own or PostHog's managed warehouse. Read before…

1.1k 3d ago A 231 tokens

daos

90

orangehrm/orangehrm

Skill Claude CodeCodex

Reference for writing query/persistence code in OrangeHRM — the plugin-specific Dao classes that extend OrangeHRM\Core\Dao\BaseDao, the EntityManagerHelperTrait and its 13 methods, the QueryBuilder patterns the codebase uses heavily (joins via relation aliases, $q->expr()->orX/andX/like/concat/in/isNull, conditional…

1.1k +2 2mo ago A 0 tokens GPL-3.0

mongodb-js/mongodb-mcp-server

Skill Claude CodeCodex

Migrates external consumer code from the mongodb-mcp-server v1/v2 single-package API to the v3 scoped-package structure. In v3, mongodb-mcp-server is a binary-only package (npx / MCPB); library embedding uses @mongodb-js/mcp-cli, @mongodb-js/mcp-core, @mongodb-js/mcp-http-runners, @mongodb-js/mcp-tools-, and the other…

1.1k +2 2d ago A 153 tokens original Apache-2.0

TencentCloudBase/CloudBase-AI-Toolkit

Skill Claude CodeCodex

Part of cloudbase-ai-toolkit

Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3 app.rdb() CRUD/RPC, PG HTTP API fallback, RLS-style permissions, username-password auth, and Web CMS/admin CRUD flows backed by CloudBase PG.

1.1k 2d ago A 77 tokens original MIT

omnigraph

93

ModernRelay/omnigraph

Skill Claude CodeCodex

Store, retrieve, and query knowledge, memory, and relationships in an Omnigraph graph, and operate a local or remote Omnigraph deployment. Use when the user wants to capture or recall facts, notes, or entities, build or query a knowledge graph or agent memory, or run Omnigraph — and whenever you see Omnigraph CLI…

1.1k 3d ago A 236 tokens original MIT

brenda-database

94

wu-yc/LabClaw

Skill Claude CodeCodex

Access BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.

1.0k +1 5mo ago A 43 tokens

plain-optimize

95

dropseed/plain

Skill Claude CodeCodex

Captures and analyzes performance traces to identify slow queries and N+1 problems. Use when a page is slow, there are too many queries, or the user asks about performance.

1.0k 6d ago A 40 tokens

doccker/cc-use-exp

Skill Claude CodeCodex

Part of cc-use-exp

A code-review guide for database access and recursive processing. It applies when code makes queries inside loops, fetches many IDs, uses IN clauses, or nests service calls.

1.0k 7d ago A 65 tokens

At most 3 mods per repository are shown here, and a mod shipped inside a plugin is left to that plugin's page — the rest are on their repository pages: