Agent Skills › phuc-nt/my-translator › ck:databases

ck:databases

GitHub

提供MongoDB和PostgreSQL的统一指南，涵盖数据库设计、SQL/NoSQL查询编写、聚合管道构建、索引优化、数据迁移及性能调优等核心任务。

.opencode/skills/databases/SKILL.md phuc-nt/my-translator

Trigger Scenarios

设计数据库模式或数据模型编写SQL或MongoDB查询语句优化查询性能或配置索引实施数据库迁移或备份恢复

Install

npx skills add phuc-nt/my-translator --skill ck:databases -g -y

More Options

Non-standard path

npx skills add https://github.com/phuc-nt/my-translator/tree/main/.opencode/skills/databases -g -y

Use without installing

npx skills use phuc-nt/my-translator@ck:databases

指定 Agent (Claude Code)

npx skills add phuc-nt/my-translator --skill ck:databases -a claude-code -g -y

安装 repo 全部 skill

npx skills add phuc-nt/my-translator --all -g -y

预览 repo 内 skill

npx skills add phuc-nt/my-translator --list

SKILL.md

Frontmatter

{
    "name": "ck:databases",
    "license": "MIT",
    "metadata": {
        "author": "claudekit",
        "version": "1.0.0"
    },
    "description": "Design schemas, write queries for MongoDB and PostgreSQL. Use for database design, SQL\/NoSQL queries, aggregation pipelines, indexes, migrations, replication, performance optimization, psql CLI.",
    "argument-hint": "[query or schema task]"
}

Databases Skill

Unified guide for working with MongoDB (document-oriented) and PostgreSQL (relational) databases. Choose the right database for your use case and master both systems.

When to Use This Skill

Use when:

Designing database schemas and data models
Writing queries (SQL or MongoDB query language)
Building aggregation pipelines or complex joins
Optimizing indexes and query performance
Implementing database migrations
Setting up replication, sharding, or clustering
Configuring backups and disaster recovery
Managing database users and permissions
Analyzing slow queries and performance issues
Administering production database deployments

Reference Navigation

Database Design

db-design.md - Activate when user requests: Database/table design for transactional (OLTP), analytics (OLAP), create or extend schema, design fact/dimension tables, analyze/review CSV/JSON/SQL files to create tables, or need advice on data storage structure.

MongoDB References

mongodb-crud.md - CRUD operations, query operators, atomic updates
mongodb-aggregation.md - Aggregation pipeline, stages, operators, patterns
mongodb-indexing.md - Index types, compound indexes, performance optimization
mongodb-atlas.md - Atlas cloud setup, clusters, monitoring, search

PostgreSQL References

postgresql-queries.md - SELECT, JOINs, subqueries, CTEs, window functions
postgresql-psql-cli.md - psql commands, meta-commands, scripting
postgresql-performance.md - EXPLAIN, query optimization, vacuum, indexes
postgresql-administration.md - User management, backups, replication, maintenance

Python Utilities

Database utility scripts in scripts/:

db_migrate.py - Generate and apply migrations for both databases (MongoDB and PostgreSQL)
db_backup.py - Backup and restore MongoDB and PostgreSQL
db_performance_check.py - Analyze slow queries and recommend indexes

# Generate migration
python scripts/db_migrate.py --db mongodb --generate "add_user_index"

# Run backup
python scripts/db_backup.py --db postgres --output /backups/

# Check performance
python scripts/db_performance_check.py --db mongodb --threshold 100ms