databases
描述
Work with MongoDB (document database) and PostgreSQL (relational database).
如何使用
- 访问 GitHub 仓库获取 SKILL.md 文件
- 将文件复制到您的项目根目录或 .cursor/rules 目录
- 重启您的 AI 助手或编辑器以应用新技能
完整技能说明
name
databases
description
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.
license
MIT
Tags
相关技能
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis.
database-migration
Execute database migrations with zero-downtime strategies and rollback procedures.
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints.
postgres-schema-design
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints.
analyzing-query-performance
Query performance analysis with comprehensive guidance and automation.