database

Design SQL and NoSQL database schemas, migrations, and operational workflows.

Updated May 5, 2026

Search Tags:#query optimization #schema design #database #postgresql #migrations #data pipeline #database operations

Ready to run

npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-movchanets

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database
Source: https://github.com/Movchanets/Microservices_Learning/tree/main/.agents/skills/database
Command: npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-movchanets

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams design, implement, optimize, and operate databases without losing consistency across schema design, migrations, performance tuning, and day-to-day administration.

Core Features & Use Cases

Database Design: Model relational or non-relational data structures, relationships, indexes, and scalability decisions.
Implementation and Migrations: Set up ORM layers, create safe migration paths, and validate data integrity during changes.
Performance and Operations: Analyze slow queries, refine indexing strategies, plan backups, and support reliable database operations.
Use Case: A product team preparing a new marketplace backend can use this Skill to design PostgreSQL tables, plan migrations, and review query performance before launch.

Quick Start

Use the database skill to design a scalable PostgreSQL schema for my application and recommend migrations, indexes, and operational safeguards.

Frequently Asked Questions about database

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

FAQPage Schema

How do I design a scalable PostgreSQL schema for a new application backend?▼

To design a scalable PostgreSQL schema, you model relational data structures, define relationships, and apply indexing strategies. This ensures your application data architecture supports growth while maintaining query performance and consistency.

What is the safest way to plan database migrations without losing data integrity?▼

Safe database migrations require creating secure migration paths and validating data integrity during schema changes. This approach prevents data loss by carefully managing structural updates and validating the transition state.

How do I optimize slow queries and improve database performance?▼

Optimizing slow queries involves analyzing the execution patterns and refining indexing strategies. This process targets performance bottlenecks to accelerate data retrieval and support reliable database operations.

Can I use this for NoSQL architecture and data pipeline quality checks?▼

Yes, this applies to both SQL and NoSQL architecture, data pipelines, and quality checks. It supports non-relational schema modeling and validates data consistency across diverse application data systems.

What are the operational safeguards needed for reliable database administration?▼

Reliable database administration requires planning backups and implementing validation checks. These operational practices ensure data recoverability and maintain system health during day-to-day operations.