One-click install
npx skills add https://github.com/toanalien/ezdevsecops --skill databases-toanalien
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/toanalien/ezdevsecops/tree/main/.opencode/skills/databases
Command: npx skills add https://github.com/toanalien/ezdevsecops --skill databases-toanalien

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines database management by providing a unified approach to designing schemas and writing queries for both MongoDB and PostgreSQL, eliminating the need to switch contexts or consult separate documentation.

Core Features & Use Cases

  • Schema Design: Create efficient schemas for both relational (PostgreSQL) and document (MongoDB) databases.
  • Query Writing: Develop complex SQL queries and MongoDB aggregation pipelines.
  • Use Case: When building a new feature that requires storing user profiles and order history, use this Skill to design the optimal schema for PostgreSQL (users, orders) and MongoDB (user activity logs), and write the necessary queries to retrieve and manipulate the data.

Quick Start

Use the databases skill to design a PostgreSQL schema for an e-commerce order system.

Frequently Asked Questions about 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 structuring relational tables and document collections efficiently. This Skill provides unified guidance to create optimal schemas for both relational and document databases without switching documentation contexts.

How do I write complex SQL queries and MongoDB aggregation pipelines?

Writing complex SQL queries and MongoDB aggregation pipelines requires structuring data retrieval and manipulation logic. This Skill guides developing advanced queries for both PostgreSQL SQL and MongoDB aggregation pipelines to retrieve and manipulate data effectively.

What's the best way to optimize database performance and indexing?

Database performance optimization and indexing improve query speed by structuring data access paths efficiently. This Skill covers indexing strategies, replication, and performance optimization techniques for both PostgreSQL and MongoDB databases.

When do I need to use PostgreSQL versus MongoDB for my application data?

Choosing PostgreSQL versus MongoDB depends on whether your application data requires relational structures or flexible document storage. This Skill helps design schemas for relational data like user profiles in PostgreSQL and document data like activity logs in MongoDB.

How do I manage database migrations and replication in PostgreSQL and MongoDB?

Managing database migrations and replication ensures data consistency across distributed database environments. This Skill provides comprehensive guidance on handling migrations, replication setup, and database management for both PostgreSQL and MongoDB systems.

Can I use psql CLI commands to interact with my PostgreSQL database?

Using psql CLI commands allows direct interaction with your PostgreSQL database for querying and administration. This Skill covers psql CLI usage alongside broader database design and query optimization guidance for PostgreSQL management.