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 73–96 of 4,314 skills

Swoole ExpertADeep reference for writing production Swoole PHP code. Covers the long-running process mental model (object lifetimes, what breaks vs php-fpm, per-request state via Coroutine::getContext), runtime hook flags (what's hookable year-to-year, what isn't), parent/child priority gotcha, Channel/WaitGroup/Barrier/defer patterns, server canonical skeleton (SWOOLE_BASE default since 5.0, dispatch modes, graceful reload rules), connection pooling (try/finally + defer, Channel-as-pool), the full pitfall...databasesgophpVotes: 0GitHub stars: 2
Database DesignADatabase schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.databasessqldatabaseVotes: 0GitHub stars: 2
X4 Update ModAPort an existing X4 mod to a newer game version (e.g. 7.x → 9.0). Runs the mechanical checks (x4validate sel/refs/completeness + XSD schema validation + the runtime migration-map heuristic) and produces a mechanical-port report plus a research-assisted design brief (feature-fate + the decisions only the user can make). Use when the user wants to update, port, or modernize a mod for the current game version.databasespythongoVotes: 0GitHub stars: 2
NotionBNotion API for creating and managing pages, databases, and blocks. Use when user asks to "take notes", "create in Notion", "update Notion page", "query database", or needs to organize information in Notion.databasesbashapiVotes: 0GitHub stars: 2
Local DbAManage local SQLite databases: create DBs, tables with relationships, execute queries, apply safe migrations (never loses data), and backup. Use when the user asks to store, query, or manage structured data locally. NOT for: unstructured document search (use rag-store), cloud databases, or key-value config storage.databasespythonbashVotes: 0GitHub stars: 2
Server ReadsAThe browser reads the database only through server functions. A read checks its arguments, verifies the caller with `requireReader`, applies who may see the rows itself, and is registered with `readOnly`. Applies whenever adding or changing something the browser reads, or a table the browser follows live.databasesgodatabaseVotes: 0GitHub stars: 5
DatabaseAUse this skill when the user needs to choose a database, design a schema, set up Supabase or another database, write queries, handle migrations, or fix data-related issues. Covers database selection, schema design, Row Level Security, migrations, and common patterns for SaaS apps built by non-technical founders.databasesrustgoVotes: 0GitHub stars: 251
PostgresARead-only PostgreSQL database querying, schema introspection, and query planning. Use when the user asks to query a database, look up data, check a table, describe a schema, list tables, show indexes, explain a query plan, or any other read-only PostgreSQL interaction. Triggers on requests like "query the users table", "show me the schema", "what tables are in staging", "run this SQL", "describe the orders table", "check the database", "how many rows in X", "explain this query".databasespythongoVotes: 0GitHub stars: 2
Prd InitAUse when the user wants to set up pwdev-prd in a project — 'inicializar o pwdev-prd', 'init prd', 'configurar PRDs' — creating the .planning/prds/ workspace and choosing language and the optional SQLite audit trail. Do NOT use to write a PRD (prd-create).databasesgobashVotes: 0GitHub stars: 3
Prd AuditAUse when the user asks about the pwdev-prd audit trail — 'auditoria do prd', 'eventos', 'decisões registradas', 'audit report', 'exportar relatório de auditoria' — querying the shared SQLite database read-only (summary, events, decisions, artifacts, stats, export, query).databasespythongoVotes: 0GitHub stars: 3
Feat AuditAUse when the user wants to query the local pwdev audit trail — 'ver auditoria', 'relatório de auditoria', 'audit stats', 'exportar auditoria em PDF' — summary, events, decisions, artifacts, statistics, a Markdown/PDF export or a custom read-only SELECT. Do NOT use to enable the audit (feat-init) or for plan status (feat-status).databasespythonsqlVotes: 0GitHub stars: 3
Commerce EngineAGoverns the shop, product catalog, and transaction logic. Use when working on Shop.tsx, PaymentSuccess.tsx, or PayPal integrations.databasesgosecurityVotes: 0GitHub stars: 2
Coding With Effect LibrariesABasic practices and guidelines for writing typescript code using that Effect TypeScript libraries (`effect`, `@effect/sql`, `@effect/platform`, `@effect/cli`, `@effect/ai`).databasestypescriptgoVotes: 0GitHub stars: 2
Codebase LibrarianACreate a comprehensive inventory of a codebase. Map structure, entry points, services, infrastructure, domain models, and data flows. Pure documentation—no opinions or recommendations. Use when onboarding to an unfamiliar codebase, documenting existing architecture before changes, preparing for architecture reviews or migration planning, or creating a reference for the team. Triggers on requests like "map this codebase", "document the architecture", "create an inventory", or "what does this c...databasesgosqlVotes: 0GitHub stars: 2
Code GenerationARun and troubleshoot project code generation (sqlc + templ).databasesgobashVotes: 0GitHub stars: 2
Code Explainer 1AExplicação detalhada de código complexo ou legado, incluindo análise linha por linha, identificação de padrões, documentação de fluxos, e tradução de lógica para linguagem natural. Usar para entender código de terceiros, documentar sistemas legados, onboarding de novos desenvolvedores, e criar documentação técnica.databasesgophpVotes: 0GitHub stars: 2
Cocoindex RustAComprehensive toolkit for developing with the CocoIndex Rust API. Use when building high-performance operators, embedding the engine in Rust applications, or extending the core framework. Covers LibContext management, custom native operators, and direct execution control.databasespythonrustVotes: 0GitHub stars: 2
Club Arena SystemABuild private poker club management and gameplaydatabasesjavascriptgoVotes: 0GitHub stars: 2
Cloudflare 6AUse this when asked to make a cloudflare workerdatabasestypescriptgoVotes: 0GitHub stars: 2
Clinvar Database 3AQuery NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.databasespythongoVotes: 0GitHub stars: 2
Client StorageAImplement client-side storage patterns using localStorage, sessionStorage, or IndexedDB. Use for persisting user preferences, caching data, handling storage quota, and migrating stored data schemas.databasestypescriptreactVotes: 0GitHub stars: 2
Clickup Push TasksAPush a local task file to ClickUp as a new task with subtasks. Use when you have a structured task file (docs/tasks/*.md) and want to create visibility in ClickUp for clients or team members. Creates parent task + phases as subtasks + items as sub-subtasks.databasesgobashVotes: 0GitHub stars: 2
Clickhouse ArchitectAClickHouse schema design authority (hub skill). Use when designing schemas, selecting compression codecs, tuning ORDER BY, optimizing queries, or reviewing table structure. **Delegates to**: clickhouse-cloud-management for user creation, clickhouse-pydantic-config for DBeaver config, schema-e2e-validation for YAML contracts. Triggers: "design ClickHouse schema", "compression codecs", "MergeTree optimization", "ORDER BY tuning", "partition key", "ClickHouse performance", "SharedMergeTree", "Re...databasespythongoVotes: 0GitHub stars: 2
Clean ModelsAClean data modeling with Pydantic, strict typing, and database hygiene. Use when designing data structures or working with storage.databasespythonrustVotes: 0GitHub stars: 2