数据库

SQL、Schema 设计、迁移和数据库操作

307 個 Skills 可用

Skills 列表

convex-agents

convex-agents

405agent-workflows

Builds AI agents on the Convex agent component: threads, messages, tools that call queries and mutations, streaming, RAG with vector search, and workflows for multi step jobs. Use when adding a chat assistant, tool calling agent, or retrieval feature to a Convex app.

waynesutton avatarwaynesutton
獲取
avoid-feature-creep

avoid-feature-creep

405code-generation

Keeps a change scoped to what was asked. Flags extra features, refactors, and 'while we are here' edits, and moves them to a suggestions list instead of the diff. Use when a request is small and the agent is about to expand it, when a PRD grows beyond its problem statement, or when the user says 'just do what I asked'.

waynesutton avatarwaynesutton
獲取
convex-component-authoring

convex-component-authoring

405database

Creates reusable Convex components with defineComponent, a clean client wrapper, their own schema, and an npm publish setup. Use when extracting a feature into a package, building something for the Convex component directory, or when a component's functions are not showing up in the parent app.

waynesutton avatarwaynesutton
獲取
convex-security-audit

convex-security-audit

404security

Deep security review patterns for authorization logic, data access boundaries, action isolation, rate limiting, and protecting sensitive operations

waynesutton avatarwaynesutton
獲取
convex-agents

convex-agents

404research-knowledge

Building AI agents with the Convex Agent component including thread management, tool integration, streaming responses, RAG patterns, and workflow orchestration

waynesutton avatarwaynesutton
獲取
convex-component-authoring

convex-component-authoring

404frontend

How to create, structure, and publish self-contained Convex components with proper isolation, exports, and dependency management

waynesutton avatarwaynesutton
獲取
convex

convex

401database

Umbrella skill for all Convex development patterns. Routes to specific skills like convex-functions, convex-realtime, convex-agents, etc.

waynesutton avatarwaynesutton
獲取
convex-best-practices

convex-best-practices

400research-knowledge

Guidelines for building production-ready Convex apps covering function organization, query patterns, validation, TypeScript usage, error handling, and the Zen of Convex design philosophy

waynesutton avatarwaynesutton
獲取
convex-schema-validator

convex-schema-validator

400database

Defining and validating database schemas with proper typing, index configuration, optional fields, unions, and migration strategies for schema changes

waynesutton avatarwaynesutton
獲取
convex-realtime

convex-realtime

400frontend

Patterns for building reactive apps including subscription management, optimistic updates, cache behavior, and paginated queries with cursor-based loading

waynesutton avatarwaynesutton
獲取
convex-cron-jobs

convex-cron-jobs

400backend-api

Scheduled function patterns for background tasks including interval scheduling, cron expressions, job monitoring, retry strategies, and best practices for long-running tasks

waynesutton avatarwaynesutton
獲取
convex-http-actions

convex-http-actions

400security

External API integration and webhook handling including HTTP endpoint routing, request/response handling, authentication, CORS configuration, and webhook signature validation

waynesutton avatarwaynesutton
獲取
convex-security-check

convex-security-check

400security

Quick security audit checklist covering authentication, function exposure, argument validation, row-level access control, and environment variable handling

waynesutton avatarwaynesutton
獲取
convex-file-storage

convex-file-storage

400database

Complete file handling including upload flows, serving files via URL, storing generated files from actions, deletion, and accessing file metadata from system tables

waynesutton avatarwaynesutton
獲取
convex-migrations

convex-migrations

400database

Schema migration strategies for evolving applications including adding new fields, backfilling data, removing deprecated fields, index migrations, and zero-downtime migration patterns

waynesutton avatarwaynesutton
獲取
swiftdata-pro

swiftdata-pro

373database

Writes, reviews, and improves SwiftData code using modern APIs and best practices. Use when reading, writing, or reviewing projects that use SwiftData.

twostraws avatartwostraws
獲取
aws-rds-spring-boot-integration

aws-rds-spring-boot-integration

329database

Provides patterns to configure AWS RDS (Aurora, MySQL, PostgreSQL) with Spring Boot applications. Configures HikariCP connection pools, implements read/write splitting, sets up IAM database authentication, enables SSL connections, and integrates with AWS Secrets Manager. Use when setting up RDS connections in Spring Boot, configuring connection pooling, or managing database credentials securely.

giuseppe-trisciuoglio avatargiuseppe-trisciuoglio
獲取
database

database

327database

This skill should be used when the user wants to add a database (Postgres, Redis, MySQL, MongoDB), says \"add postgres\", \"add redis\", \"add database\", \"connect to database\", or \"wire up the database\". For other templates (Ghost, Strapi, n8n, etc.), use the templates skill.

railwayapp avatarrailwayapp
獲取
architecture-diagrams

architecture-diagrams

317database

Create system architecture diagrams using Mermaid, PlantUML, C4 model, flowcharts, and sequence diagrams. Use when documenting architecture, system design, data flows, or technical workflows.

aj-geddes avataraj-geddes
獲取
drizzle-orm-patterns

drizzle-orm-patterns

312database

Provides comprehensive Drizzle ORM patterns for schema definition, CRUD operations, relations, queries, transactions, and migrations. Proactively use for any Drizzle ORM development including defining database schemas, writing type-safe queries, implementing relations, managing transactions, and setting up migrations with Drizzle Kit. Supports PostgreSQL, MySQL, SQLite, MSSQL, and CockroachDB.

giuseppe-trisciuoglio avatargiuseppe-trisciuoglio
獲取
nodejs-express-server

nodejs-express-server

301database

Build production-ready Express.js servers with middleware, authentication, routing, and database integration. Use when creating REST APIs, managing requests/responses, implementing middleware chains, and handling server logic.

aj-geddes avataraj-geddes
獲取
databricks-core

databricks-core

289database

Databricks CLI operations and the parent/entry-point skill for Databricks CLI use: authentication, profile selection, and bundles. Load this first for CLI, auth, profile, and bundle tasks, then load the matching product skill. For finding or exploring data, answering questions about the data, or generating SQL, load the databricks-data-discovery skill (it routes to Genie One). Contains up-to-date guidelines for Databricks-related CLI tasks.

databricks avatardatabricks
獲取
drizzle-orm

drizzle-orm

260database

Guidelines for developing with Drizzle ORM, a lightweight type-safe TypeScript ORM with SQL-like syntax

mindrally avatarmindrally
獲取
postgresql-best-practices

postgresql-best-practices

248database

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

mindrally avatarmindrally
獲取