skills.rest
farmountain
farmountainCOMMUNITY
Explore all skills by this author →
GitHub

Database Expert

Design PostgreSQL schemas and plan safe database migrations.

1|Updated Jan 29, 2026
Search Tags:#performance#schema design#database#postgresql#migrations#sql#mysql
One-click install
npx skills add https://github.com/farmountain/sdlc_agent_swarm --skill database-expert-farmountain
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Expert
Source: https://github.com/farmountain/sdlc_agent_swarm/tree/main/vscode-sdlc-swarm/templates/.agents/skills/domain/database-expert
Command: npx skills add https://github.com/farmountain/sdlc_agent_swarm --skill database-expert-farmountain

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the complexities of designing, implementing, and maintaining robust database systems, ensuring data integrity, performance, and operational readiness.

Core Features & Use Cases

  • Schema Design: Creates optimal database schemas based on data models and access patterns.
  • Migration Strategy: Plans and executes safe, backward-compatible database migrations.
  • Performance Tuning: Identifies and resolves slow queries and optimizes indexing.
  • Use Case: When building a new multi-tenant SaaS application, this Skill will design a secure and scalable PostgreSQL schema, define a zero-downtime migration strategy for future updates, and recommend indexing for critical read paths.

Quick Start

Use the Database Expert skill to design a PostgreSQL schema for a multi-tenant application with user and order data.

Frequently Asked Questions about Database Expert

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

FAQPage Schema
How do I design a scalable PostgreSQL schema for a multi-tenant application?▼

To design a scalable PostgreSQL schema, define data models and access patterns, enforce data integrity, and recommend indexing for critical read paths. This ensures secure, optimal schema structures tailored for multi-tenant workloads.

How do I execute zero-downtime database migrations in production?▼

To execute zero-downtime database migrations, plan and execute safe, backward-compatible schema updates. This strategy prevents operational disruption by ensuring migrations are fully compatible with existing production environments.

What is the best way to optimize slow SQL queries and indexing?▼

The best way to optimize slow SQL queries is performance tuning, which identifies and resolves slow queries while optimizing indexing strategies. This directly targets and resolves critical read path bottlenecks.

Does this database architecture guidance support both MySQL and SQLite?▼

Yes, the database architecture guidance supports PostgreSQL, MySQL, and SQLite. It enforces data integrity, performance targets, and operational readiness consistently across these specific database systems.

What transaction strategy should I use for high-volume database systems?▼

A robust transaction strategy for high-volume databases enforces strict data integrity and operational readiness. It balances performance targets with reliable execution across your chosen database system.

Related Skills

Explore More Software Engineering Skills→
tachfineamnaytachfineamnay

Data Models & Schema

Document Prisma models, relations, and constraints from schema.prisma.

Community
Advanced
mosheshammoshesham

database-designer

Design PostgreSQL schemas with pgvector embeddings and optimized indexing.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
rnavarychrnavarych
14

role-database:newsql-distributed

Compare 12 NewSQL and distributed SQL databases for consistency and sharding.

Community
Advanced