数据库

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

359 个 Skills 可用

Skills 列表

eloquent-best-practices

eloquent-best-practices

44database

Best practices for Laravel Eloquent ORM including query optimization, relationship management, and avoiding common pitfalls like N+1 queries.

iserter avatariserter
获取
prisma-cli

prisma-cli

43database

Prisma ORM CLI 命令参考,涵盖 init、generate、migrate、db、dev、studio、validate、format、debug 和 mcp。用于 ORM/数据库 CLI 工作流,不用于 Prisma Compute 应用部署。对于 Prisma Compute,请使用 `prisma-compute` 技能处理 `@prisma/cli app deploy`、`compute:deploy`、`create-prisma --deploy`、应用、部署、日志或域名。触发词为 "prisma init"、"prisma generate"、"prisma migrate"、"prisma db"、"prisma studio"、"prisma mcp"。

prisma avatarprisma
获取
prisma-database-setup

prisma-database-setup

42database

配置 Prisma 与不同数据库提供商(PostgreSQL、MySQL、SQLite、MongoDB 等)的指南。适用于新建项目、切换数据库或排查连接问题。触发词包括“配置 postgres”、“连接 mysql”、“设置 mongodb”、“sqlite 设置”。

prisma avatarprisma
获取
prisma-client-api

prisma-client-api

42database

Prisma Client API 参考,涵盖模型查询、过滤器、操作符和客户端方法。在编写数据库查询、使用 CRUD 操作、过滤数据或配置 Prisma Client 时使用。触发词为 "prisma query"、"findMany"、"create"、"update"、"delete"、"$transaction"。

prisma avatarprisma
获取
convex-migrate

convex-migrate

42database

Migrate schema + backfill data on a deployed Convex app using @convex-dev/migrations.

get-convex avatarget-convex
获取
convex-migrate-rehearse

convex-migrate-rehearse

42database

Rehearse a live-app schema change + backfill on a snapshot-seeded preview deployment, verify, then promote the proven change to prod with the snapshot as rollback.

get-convex avatarget-convex
获取
convex-seed

convex-seed

42database

Seed or import data into the Convex database.

get-convex avatarget-convex
获取
convex-launch-readiness

convex-launch-readiness

42database

Run every Convex audit (authz, reviewer, advisor, insights) into one scored, deduped readiness report with an ordered fix plan — Lighthouse for your backend.

get-convex avatarget-convex
获取
aws-diagrams

aws-diagrams

39database

Visualizes AWS infrastructure from CLI output, CloudFormation, or descriptions. Use when user has AWS resources to diagram.

eraserlabs avatareraserlabs
获取
netlify-database

netlify-database

34database

Zero-config Postgres for Netlify apps via @netlify/database — querying data from Functions/Edge Functions, writing schema migrations, setting up Drizzle ORM, local dev with netlify dev, database branches for deploy previews, and migrating an existing Postgres project onto Netlify. Use when adding a database, building a contact form or CRUD API, writing SQL migrations, wiring up Drizzle, running netlify database commands, testing with a local Postgres, or switching from Neon/Supabase/RDS to Netlify Database.

netlify avatarnetlify
获取
vibe-prospecting

vibe-prospecting

34database

Find company & contact data. Turn your agent into a prospecting platform. Get contact information, roles, tech stack, business events, website changes, intent data. Build lead lists, research prospects, identify talent. 150M+ companies, 800M+ professionals, 50+ data sources.

cline avatarcline
获取
postgres-best-practices

postgres-best-practices

29database

Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use when writing SQL, designing database schemas, optimizing queries, or setting up a Postgres database.

neondatabase avatarneondatabase
获取
rivet-actors

rivet-actors

29database

Actors: The primitive for agent orchestration.

rivet-dev avatarrivet-dev
获取
prisma-orm-v7-skills

prisma-orm-v7-skills

23database

Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting

gocallum avatargocallum
获取
powersync

powersync

18database

Best practices for building and maintaining applications with PowerSync: Cloud and self-hosted setup, sync configuration, client SDK usage, backend integration (Supabase, custom Postgres, MongoDB, Azure DocumentDB, MySQL, MSSQL), schema changes, watch and reactive queries (useQuery), attachments, the upload queue, and debugging. Use this skill whenever the user mentions PowerSync, a @powersync/* package (@powersync/web, @powersync/react-native, @powersync/node), the powersync Flutter/Dart package, wa-sqlite, offline-first sync, local-first architecture, sync rules, sync streams, uploadData, fetchCredentials, disconnectAndClear, logout or user switching in a synced app, real-time data replication, Electric Cloud migration, Electric Shapes, an app stuck on Syncing, data not syncing, or wants to add offline-capable sync to a mobile or web app, even if they do not explicitly name PowerSync.

powersync-ja avatarpowersync-ja
获取
valibot

valibot

15database

Schema validation with Valibot, the modular and type-safe schema library. Use when the user needs to validate data, create schemas, parse inputs, or work with Valibot in their project. Also use when migrating from Zod to Valibot.

open-circle avataropen-circle
获取
pentest-agents-bug-bounty-framework

pentest-agents-bug-bounty-framework

11database

Autonomous bug bounty agent framework with 50 agents, hunt loops, exploit chains, MCP servers for platform integration and writeup search

reason-machines avatarreason-machines
获取
sqlalchemy-alembic-expert-best-practices-code-review

sqlalchemy-alembic-expert-best-practices-code-review

8database

SQLAlchemy ORM and Alembic migration best practices for building safe, performant database schemas. This skill should be used when writing, reviewing, or refactoring SQLAlchemy models, Alembic migrations, or database query patterns. Triggers on tasks involving SQLAlchemy ORM, Alembic migrations, database schema changes, or query optimization.

wispbit-ai avatarwispbit-ai
获取
apache-airflow-orchestration

apache-airflow-orchestration

5database

Expert knowledge of Apache Airflow for building, scheduling, and monitoring data pipelines and workflows

aradotso avatararadotso
获取
apache-airflow-orchestration

apache-airflow-orchestration

5database

Expert knowledge of Apache Airflow for building, scheduling, and monitoring data pipelines and workflows

reason-machines avatarreason-machines
获取
employee-performance-analytics-hr

employee-performance-analytics-hr

5database

SQL and Python-based employee performance analytics with KPI aggregation, departmental insights, and HR dashboard generation

reason-machines avatarreason-machines
获取
data-engineering-medallion-pipeline

data-engineering-medallion-pipeline

5database

End-to-end data engineering pipeline using MinIO, Airbyte, PostgreSQL, DBT, and Airflow with medallion architecture (Bronze/Silver/Gold layers)

reason-machines avatarreason-machines
获取
realtime-cinema-data-engineering-pipeline

realtime-cinema-data-engineering-pipeline

5database

Build end-to-end real-time data pipelines with Kafka, PostgreSQL, Airflow, and Streamlit using Medallion Architecture for streaming analytics.

reason-machines avatarreason-machines
获取
harvard-art-museums-etl-analytics

harvard-art-museums-etl-analytics

5database

Build ETL pipelines and analytics dashboards using Harvard Art Museums API with Python, SQL, and Streamlit

reason-machines avatarreason-machines
获取