skills.rest
droppii
droppiiOFFICIAL
Explore all skills by this author →
GitHub

ck:databases

Design database schemas and write queries for MongoDB and PostgreSQL.

Updated Aug 23, 2026
Search Tags:#postgresql#sql#nosql#query-optimization#mongodb#databases#schema-design
One-click install
npx skills add https://github.com/droppii/droppii-agents --skill ck-databases-droppii
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/droppii/droppii-agents/tree/main/cursor/skills/databases
Command: npx skills add https://github.com/droppii/droppii-agents --skill ck-databases-droppii

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Design robust database schemas and write efficient queries for MongoDB and PostgreSQL to support scalable data models and reliable data access.

Core Features & Use Cases

  • Schema design guidance for document-oriented and relational models
  • Cross-database SQL and MongoDB query authoring, including migrations and indexing
  • Use cases spanning OLTP, analytics pipelines, data migrations, and performance tuning

Quick Start

Provide a data model and two sample queries to begin applying database design and query optimization tasks.

Frequently Asked Questions about ck:databases

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a database schema for both PostgreSQL and MongoDB?▼

Database schema design for PostgreSQL and MongoDB involves modeling relational tables and document-oriented structures to support scalable data access. This Skill guides schema generation, indexing best practices, and cross-database migrations.

What's the best way to optimize slow SQL queries and MongoDB aggregations?▼

Query optimization for SQL and MongoDB requires analyzing execution plans and applying proper indexing strategies. This Skill writes efficient queries, builds aggregation pipelines, and tunes performance for OLTP and analytics pipelines.

Can I use this for cross-database migrations and workflow planning?▼

Cross-database migrations between PostgreSQL and MongoDB are supported for workflow planning. It handles schema mapping, data transformations, and operational tooling via provided scripts to ensure reliable data transfers.

Does this work for both OLTP transaction processing and analytics pipelines?▼

OLTP and analytics pipelines are both supported by the database design and query authoring capabilities. It structures schemas and tunes queries to handle high-volume transactions and complex analytical aggregations effectively.

How do I start modeling data and writing queries for my application?▼

Provide a data model and two sample queries to start the database design process. The system then generates schema structures, optimizes query syntax, and recommends indexing strategies for your specific workload.

When should I choose a document-oriented schema over a relational model?▼

Document-oriented MongoDB schemas suit flexible, hierarchical data, while relational PostgreSQL models enforce strict consistency. This Skill evaluates your data model requirements to recommend the appropriate schema design and query patterns.

Related Skills

Explore More Data & Analytics Skills→
productengineeredproductengineered

swiftdata-architecture

Design SwiftData schemas, queries, repositories, and performance optimizations for iOS and macOS apps.

Community
Advanced
mDevsLabsmDevsLabs
1

db-migrations

Generate and validate idempotent Drizzle database migration scripts.

Community
Intermediate
yunqiqiliangyunqiqiliang
8

clickzetta-oss-ingest-pipeline

Automate object storage ingestion pipelines into Lakehouse with COPY/INSERT and PIPE management.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate