Databases

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

skills in category: 4,315
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,577–3,600 of 4,315 skills

Migration PatternsASafe schema-migration patterns for systems under live traffic — expand/contract, backfill, double-write, shadow-read, online DDL. Use when authoring, reviewing, or sequencing a migration that can't take a maintenance window.databasesgosqlVotes: 0GitHub stars: 2
PostgresAPostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.databasessqlgitVotes: 0GitHub stars: 294
MysqlAPlan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database.databasesgosqlVotes: 0GitHub stars: 294
Obsidian BasesAExplain, draft, and validate Obsidian Bases .base files with filters, formulas, properties, summaries, and table, card, or list views. Use for Obsidian Bases, database-like vault views, dynamic tables, reading lists, task trackers, filters, formulas, summaries, and .base file edits.databasespythonbashVotes: 0GitHub stars: 15,078
Mx Pg Controller MigrationAUse when verifying and porting an mx-core controller (Post/Note/Page/Comment/Category/etc.) after the MongoDB→PostgreSQL cutover, or when its data shape no longer matches what api-client and admin-vue3 expect. Triggers on "校验 controller"、"check controller"、"迁移 controller"、"修复迁移后的接口"、"data missing after PG migration"、"related/category 字段丢了" and similar.databasesrustgoVotes: 0GitHub stars: 564
Mx Migration AuthorAAuthor and review Drizzle SQL migrations safely for rolling deploys. Triggers when editing apps/core/src/database/schema/*.ts or apps/core/src/database/migrations/*.sql, when the user runs drizzle-kit generate, when "lint-migrations" reports a violation, or on prompts like "迁移", "改 schema", "alter table", "add a column", "drop column", "migration safety". Enforces the expand-contract pattern because mx-core ships rolling deploys (Dokploy, 2 replicas) where new and old pods coexist for tens of...databasessqlapiVotes: 0GitHub stars: 564
Create ModuleACreate a new NestJS module with repository, service, controller, schema, and Drizzle table definition. Use when adding new feature modules, API endpoints, or business domains.databasestypescriptgoVotes: 0GitHub stars: 564
Create E2e TestACreate E2E test file for a specified module. Use when adding end-to-end tests for controllers or unit tests for services and repositories.databasestypescriptgoVotes: 0GitHub stars: 564
Database OperationsAPerform Drupal database operations including backups, restores, queries, and migrations. Use for database maintenance, troubleshooting, and data operations.databasesphpbashVotes: 0GitHub stars: 4
DataASet up database / persistent-state discipline for a project with a DB. Authors a data-auditor agent (5 categories of integrity check), a migration-create skill, query-discipline rule (CLI > MCP DB tool for reads), and edit-time regen hook — all derived from the project's actual schema, migration framework, and access-control model. Optionally an RLS-security-reviewer if Postgres + row-level security is in use. Invoke /dotclaude:data in any project with persistent state.databasesgobashVotes: 0GitHub stars: 2
Feishu BitableA飞书多维表格（Bitable）的创建、查询、编辑和管理工具。包含 27 种字段类型支持、高级筛选、批量操作和视图管理。 **当以下情况时使用此 Skill**： (1) 需要创建或管理飞书多维表格 App (2) 需要在多维表格中新增、查询、修改、删除记录（行数据） (3) 需要管理字段（列）、视图、数据表 (4) 用户提到"多维表格"、"bitable"、"数据表"、"记录"、"字段" (5) 需要批量导入数据或批量更新多维表格databasesapiVotes: 0GitHub stars: 6,472
Activity RecordAQuery and orchestrate Arkloop Activity Record local activity data. Covers browser history, search terms, screen time, bluetooth, shell commands, window focus, keyboard, mouse, clipboard, Codex sessions, and optional Screenpipe integration.databasesgoshellVotes: 0GitHub stars: 375
Write NqlAWrite, validate, and (optionally) execute an NQL query against a Narrative dataset. Drafts the query from the user's question, runs `narrative_nql_validate` until it compiles, explains the query in plain English, and only runs it on explicit approval (or when invoked with `--run`). Use when: "write an NQL query for X", "query this dataset", "validate this NQL", "run NQL against dataset <id>", "how many rows match Y", "show me the top N records from <dataset>". (narrative-common)databasesgosqlVotes: 0GitHub stars: 9
Swift PersistenceAImplements a persistence layer using SwiftData or CoreData following MVVM — models, repository abstraction, and testable in-memory setup. Use when user says "add CoreData", "set up SwiftData", "persist data", "save to database", "add a data model", "create Core Data entities", or "use SwiftData models".databasesgoswiftVotes: 0GitHub stars: 5
Run CiARun the full CI pipeline locally. Use this skill when opening or updating a PR, when a change is workspace-wide (Cargo.toml/Cargo.lock, DTO/RPC types, DB migrations, broad refactor), or when the user says 'run ci', 'check ci', 'full ci', or 'will ci pass'. Do NOT use it for routine commits and pushes — those only need a format run and the tests covering the change.databasespythonrustVotes: 0GitHub stars: 192
Migrate PrAMigrate an open PR from a related repository (tycho-protocol-sdk, tycho-simulation, tycho-execution) into this monorepo. Rewrites paths, strips unmapped diffs, and handles conflicts. Use when the user says 'migrate PR', 'port PR', or 'bring over PR from <repo>'.databasesgobashVotes: 0GitHub stars: 192
Shopify App Offline Access TokensAExpiring offline access tokens, migrations, and refresh behavior for kyon147/laravel-shopify in a host Laravel app.databasesphpapiVotes: 0GitHub stars: 494
Exasol DatabaseAExasol database interaction via exapump CLI and Exasol SQL. Covers file upload/export, SQL queries, and Exasol-specific SQL behavior including data types, reserved keywords, and constraints.databasesgosqlVotes: 0GitHub stars: 10
Exasol BucketfsAExasol BucketFS file system management via exapump CLI. Covers listing, uploading, downloading, and deleting files and directories in BucketFS, BucketFS configuration, bucket structure, and use with UDFs.databasespythonjavaVotes: 0GitHub stars: 10
Aurelius ObjectsASave, load, update, delete, merge, and navigate entity objects using TMS Aurelius ORM (TObjectManager). Use when the user asks how to persist or retrieve data with Aurelius, manage object lifetime, work with associations or collections at runtime, handle transactions, use cached updates, or control concurrency. Does NOT cover query DSL or criteria/projections (those are in a separate skill). Triggers on requests like "save an entity with Aurelius", "load a customer from the database", "add it...databasessqldatabaseVotes: 0GitHub stars: 14
Aurelius MappingAMap Delphi classes to a relational database using TMS Aurelius ORM attributes. Use when the user asks to create entity classes, add Aurelius mapping to existing classes, fix or review mapping attributes, explain how a class is mapped, or work with associations, inheritance, automapping, nullable fields, blobs, or composite identifiers. Triggers on requests like "create Aurelius entities for...", "map this class to Aurelius", "add ORM mapping", "fix the mapping on this class", "how do I map a ...databasesdatabaseVotes: 0GitHub stars: 14
Supabase To D1AMigrate data from Supabase PostgreSQL to Cloudflare D1. Use when the user wants to migrate, transfer, copy, or move data from Supabase (or any PostgreSQL database) to Cloudflare D1, or when they mention "supabase to d1", "pg to d1", "postgres to sqlite", or ask about switching database providers from PostgreSQL to D1.databasespythonshellVotes: 0GitHub stars: 3
Configure NightwatchAConfigures Laravel Nightwatch data collection, sampling rates, filtering rules, and redaction policies. Use when setting up Nightwatch, managing data volume, protecting sensitive data (PII), or optimizing event collection for production workloads.databasesgophpVotes: 0GitHub stars: 375
paperless-ngxASearch and retrieve documents from a Paperless-ngx archive via REST API. Use when the user wants to find, read, or update documents stored in Paperless-ngx (for example: search by keyword or tag, fetch document content, or update document metadata).databasespythonbashVotes: 0GitHub stars: 8