Database

SQL, schema design, migrations, and database operations

359 skills available

Skills List

qdrant-clients-sdk

qdrant-clients-sdk

222code-generation

Qdrant provides client SDKs for various programming languages, allowing easy integration with Qdrant deployments.

qdrant avatarqdrant
Get
mysql-best-practices

mysql-best-practices

211database

MySQL development best practices for schema design, query optimization, and database administration

mindrally avatarmindrally
Get
database-observability

database-observability

211database

Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables `pg_stat_statements` / Performance Schema, creates a least-privilege monitoring user, configures the `database_observability.postgres` / `database_observability.mysql` Alloy components, ships query samples + visual explain plans + RED metrics + schema details to Grafana Cloud, and correlates slow queries with application traces via `db.statement` / `db.system` OTel attributes. Use when monitoring database performance, diagnosing slow queries, setting up DB observability for RDS / Aurora / Cloud SQL / Azure Database / self-managed instances, correlating DB metrics with APM, or alerting on query latency — even when the user says "my database is slow", "find the slow queries", or "monitor RDS" without saying "observability".

grafana avatargrafana
Get
wp-plugin-development

wp-plugin-development

211database

Use when developing WordPress plugins: architecture and hooks, activation/deactivation/uninstall, admin UI and Settings API, data storage, cron/tasks, security (nonces/capabilities/sanitization/escaping), and release packaging.

automattic avatarautomattic
Get
langchain-dev-guide

langchain-dev-guide

189research-knowledge

LangChain / LangGraph engineering pitfalls and verified fixes. Covers DeepAgents, structured output, OpenAI-compatible model integration (including Chinese provider adapters: DeepSeek, Qwen, GLM, etc.), middleware, streaming, multi-agent orchestration, and other common development issues. Use when hitting unexpected behavior, making architecture decisions, or integrating Chinese LLM providers during LangChain development.

ob-labs avatarob-labs
Get
react-native-mmkv

react-native-mmkv

173database

Fast synchronous key-value storage for React Native via react-native-mmkv (Nitro-backed). Covers creating and configuring MMKV instances, reading/writing all value types (string, number, boolean, buffer), React hooks for reactive UI, value-change listeners, encryption, AsyncStorage migration, and state-management integrations (zustand, redux-persist, jotai, react-query). Also covers storage limits, multi-process mode, and the V4 upgrade from the class-based API.

margelo avatarmargelo
Get
sanity-migration

sanity-migration

165database

Plans, implements, and reviews migrations from other CMSes and content systems into Sanity. Use when migrating or replatforming to Sanity from AEM, Adobe Experience Manager, Contentful, Strapi, Webflow, WordPress, Payload, Drupal, Markdown/MDX/frontmatter files, WXR/XML exports, CMS APIs, database dumps, static HTML, or when designing extraction, transformation, Portable Text conversion, asset migration, redirects, validation, and cutover workflows.

sanity-io avatarsanity-io
Get
database-testing

database-testing

156database

Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues. Covers PostgreSQL, MySQL, MongoDB with Prisma, TypeORM, Drizzle, and SQLAlchemy, plus Testcontainers test databases. Use when: "database test," "migration test," "migration rollback," "rollback test," "data integrity," "SQL test," "schema validation," "seed data," "query performance," "Testcontainers." Not for: synthetic data generation/masking at scale — use test-data-management; Docker/IaC test-environment provisioning — use test-environments; SQL injection — use security-testing. Related: test-data-management, test-environments, security-testing, ci-cd-integration.

petrkindlmann avatarpetrkindlmann
Get
test-data-management

test-data-management

156database

Create and manage test data with factory patterns, fixture strategies, data anonymization, and synthetic data generation. Covers Fishery (TypeScript), FactoryBot (Ruby), Factory Boy (Python), database seeding, cleanup strategies, and GDPR-compliant data handling. Use when: "test data," "fixtures," "factories," "seed data," "synthetic data," "test database," "data anonymization." Not for: migration/integrity testing of the DB itself — use database-testing; environment provisioning and database branching strategy — use test-environments. Related: test-environments, database-testing, api-testing, unit-testing.

petrkindlmann avatarpetrkindlmann
Get
test-environments

test-environments

156database

Design environment strategy for testing across dev, CI, preview, staging, and production — Docker Compose test infrastructure, multi-stage Dockerfiles, seed-data lifecycle, per-PR preview environments, production parity, and external-dependency stubbing at the HTTP boundary. Use when: "set up test environment," "docker-compose for tests," "per-PR preview environment," "staging parity," "spin up test infra," "environment tiers." Not for: choosing mock-vs-stub-vs-fake per dependency — use service-virtualization; factory and fixture data patterns — use test-data-management; pipeline/Actions config — use ci-cd-integration. Related: test-data-management, ci-cd-integration, contract-testing, service-virtualization.

petrkindlmann avatarpetrkindlmann
Get
cms-migration

cms-migration

150database

Use when user wants to migrate content from another CMS (WordPress, Contentful, Strapi, Sanity, Webflow, etc.) to Payload CMS

payloadcms avatarpayloadcms
Get
django-safe-migration

django-safe-migration

149database

Write, review, and rewrite Django migrations for PostgreSQL with zero-downtime guarantees. Use this skill whenever the user mentions migrations, Django schema changes, or deployment safety — even if they don't say "zero downtime" explicitly. Trigger on: "review this migration", "is this migration safe?", "write a migration for...", "rewrite this migration", "how do I add a NOT NULL column / drop a column / add an index / rename a column / add a FK without downtime", "will this migration cause locks?", "this migration is blocking production". Covers: SeparateDatabaseAndState two-file splits, AddIndexConcurrently, FK NOT VALID + VALIDATE, db_default for NOT NULL columns, lock_timeout, and RunPython safety rules.

vintasoftware avatarvintasoftware
Get
caveman

caveman

134database

Ultra-compressed communication mode. Cuts token usage ~75% by speaking like caveman while keeping full technical accuracy. Supports intensity levels: lite, full (default), ultra, wenyan-lite, wenyan-full, wenyan-ultra. Use when user says "caveman mode", "talk like caveman", "use caveman", "less tokens", "be brief", or invokes /caveman. Also auto-triggers when token efficiency is requested.

juliusbrussee avatarjuliusbrussee
Get
planetscale-change-gates-and-approval-contract

planetscale-change-gates-and-approval-contract

128database

Enforce explicit approval gates for any PlanetScale, database, repository, credential, network, or automation mutation.

planetscale avatarplanetscale
Get
planetscale-traffic-control-recommendations

planetscale-traffic-control-recommendations

128database

Build a safe recommendation plan for PlanetScale Postgres Database Traffic Control budgets and rules without applying them.

planetscale avatarplanetscale
Get
planetscale-webhook-automation-recommendations

planetscale-webhook-automation-recommendations

128database

Recommend webhook subscriptions and safe automation patterns for PlanetScale alerts, anomalies, schema recommendations, deploy requests, and agent workflows.

planetscale avatarplanetscale
Get
planetscale-customer-report-template

planetscale-customer-report-template

128database

Produce the final PlanetScale best-practices report after running the inventory and relevant review skills.

planetscale avatarplanetscale
Get
planetscale-vitess-safety-review

planetscale-vitess-safety-review

128database

Review a PlanetScale Vitess database for safe migrations, deploy requests, schema recommendations, Insights, webhooks, and operational safety.

planetscale avatarplanetscale
Get
planetscale-codebase-sqlcommenter-instrumentation

planetscale-codebase-sqlcommenter-instrumentation

127database

Inspect an application repository connected to PlanetScale and recommend SQLCommenter-compatible query tagging packages and conventions.

planetscale avatarplanetscale
Get
planetscale-query-insights-and-tags

planetscale-query-insights-and-tags

126database

Use PlanetScale Insights and SQLCommenter-style query tags to attribute database load, identify risky queries, and prepare safe Traffic Control or schema recommendations.

planetscale avatarplanetscale
Get
planetscale-schema-recommendations-agent-loop

planetscale-schema-recommendations-agent-loop

126database

Safely triage PlanetScale schema recommendations and turn them into reviewed branches, migrations, issues, or pull requests without applying production changes.

planetscale avatarplanetscale
Get
planetscale-safe-orchestrator

planetscale-safe-orchestrator

126database

Master skill that runs the full PlanetScale safe best-practices assessment — inventory, engine review, Insights, Traffic Control, webhooks, schema recommendations, codebase instrumentation, and agent operating model — then produces a unified recommendations report. Never applies changes without explicit approval. Use when the user asks to run the full assessment, all skills, or PlanetScale best-practices review.

planetscale avatarplanetscale
Get
planetscale-pscale-cli-automation

planetscale-pscale-cli-automation

126database

Use the PlanetScale CLI (pscale) from automated agents with --format json, auth check, pscale sql, and per-command --force. Run before other PlanetScale skills when driving pscale directly. Use when the user asks to automate pscale, run CLI commands headless, or verify pscale auth from an agent.

planetscale avatarplanetscale
Get
check-impl-against-spec

check-impl-against-spec

125database

Compare a pull request's implementation against spec context in spec_context.md and feed any material mismatches into review.json. Use during PR review when approved or repository spec context is available.

warpdotdev avatarwarpdotdev
Get