skills.rest
Movchanets
MovchanetsCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-movchanets
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
ArianHobson333ArianHobson333
7

roe-template

Generate Rules of Engagement documents from structured schema input.

Community
Intermediate
promptrankspromptranks

prk-psv-export

Export validated PSV samples to SQL or JSON for database import.

Official
Intermediate
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
Mentor-WizardMentor-Wizard
10

postgresql-optimization

Analyze PostgreSQL queries with EXPLAIN ANALYZE and tune indexes and configuration.

Official
Advanced