ck:databases

Design database schemas and write SQL and MongoDB queries.

Updated Jan 11, 2026
One-click install
npx skills add https://github.com/felix-howard/ella --skill ck-databases-felix-howard
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/felix-howard/ella/tree/main/.opencode/skills/databases
Command: npx skills add https://github.com/felix-howard/ella --skill ck-databases-felix-howard

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines database interactions by providing a unified interface for designing schemas and writing queries for both MongoDB and PostgreSQL.

Core Features & Use Cases

  • Schema Design: Create and modify database schemas for transactional (OLTP) and analytical (OLAP) workloads.
  • Query Writing: Write efficient SQL and MongoDB query language statements.
  • Use Case: You need to design a PostgreSQL schema for an e-commerce platform, including tables for users, products, and orders, and then write queries to retrieve customer order history.

Quick Start

Use the ck:databases skill to design a PostgreSQL table for users with id, name, and email columns.

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 an e-commerce platform in PostgreSQL?

To design a database schema for PostgreSQL, you define tables for core entities like users, products, and orders. This skill streamlines schema design for both transactional and analytical workloads, generating the required table structures and relationships.

What is the best way to write efficient SQL queries for customer order history?

Writing efficient SQL queries involves structuring statements to retrieve customer order history accurately. This skill writes optimized SQL queries and supports performance optimization through proper indexing to ensure fast data retrieval.

Can I build MongoDB aggregation pipelines for complex data queries?

Yes, you can build MongoDB aggregation pipelines for complex data queries. The skill writes efficient MongoDB query language statements and supports database design specifically for NoSQL data structures.

How do I manage database migrations and replication effectively?

Managing database migrations and replication effectively requires structured schema changes and data synchronization. This skill supports both migrations and replication setup, ensuring database schemas remain consistent across different environments.

Does this tool help with query optimization and psql CLI usage?

Yes, the tool helps with query optimization and psql CLI usage. It supports performance optimization for database interactions and provides guidance on executing commands directly through the PostgreSQL command line interface.