skills.rest
BasharAmso
BasharAmsoCOMMUNITY
Explore all skills by this author →
GitHub

Database Administration

Design database schemas, write migrations, and optimize queries for PostgreSQL and ORM projects.

1|Updated Mar 11, 2026
Search Tags:#indexing#database#postgresql#migrations#orm#query-optimization#schema-design
One-click install
npx skills add https://github.com/BasharAmso/Bashi --skill database-administration
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Administration
Source: https://github.com/BasharAmso/Bashi/tree/main/create-bashi-app/template/.claude/skills/database-admin
Command: npx skills add https://github.com/BasharAmso/Bashi --skill database-administration

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Design database schemas, write migrations, and optimize queries to ensure robust data models and maintainable, evolvable databases across applications.

Core Features & Use Cases

  • Schema design guidance for relational systems, including normalization and relationships.
  • Migration planning with UP/DOWN semantics, indexing strategies, and data migrations.
  • Performance optimization through query tuning and index selection for ORM-driven apps.
  • Use Case: Build a new service's data layer from scratch, then evolve the schema safely as requirements change.

Quick Start

Run an initial schema design session to establish tables, relationships, and migrations for your project.

Frequently Asked Questions about Database Administration

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

FAQPage Schema
How do I design a PostgreSQL schema and write safe database migrations?▼

Schema design for relational systems involves structuring tables, applying normalization, and defining relationships. This process ensures robust data models and maintainable databases before you write any migration scripts.

What's the best way to optimize slow ORM queries in PostgreSQL?▼

The best way to optimize slow ORM queries is through query tuning and strategic index selection based on your schema design, ensuring the database engine retrieves data efficiently without full table scans.

Does this database migration approach support rollback for ORM-based projects?▼

Yes, this database migration approach supports rollback for ORM-based projects by enforcing migrations with distinct UP and DOWN sections, allowing you to safely reverse schema changes if needed.

When do I need to add indexing to my database schema design?▼

You need to add indexing to your database schema design when optimizing query performance for specific access patterns. Proper indexing strategies ensure fast data retrieval in ORM-driven applications.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
felvieirafelvieira
22

backend-api

Define API contracts and data models for Node.js backend applications.

Community
Advanced
pascallammerspascallammers
1

database-design

Design normalized relational and NoSQL database schemas with indexes and migrations.

Community
Advanced