skills.rest
christopherlouet
christopherlouetCOMMUNITY
Explore all skills by this author →
GitHub

ops-database

Design database schemas, indexes, and migrations with SQL and TypeScript scripts.

5|Updated Jan 15, 2026
Search Tags:#indexing#schema design#database#postgresql#migration#sql
One-click install
npx skills add https://github.com/christopherlouet/claude-base --skill ops-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ops-database
Source: https://github.com/christopherlouet/claude-base/tree/main/.claude/skills/ops-database
Command: npx skills add https://github.com/christopherlouet/claude-base --skill ops-database

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies the process of designing, optimizing, and migrating database schemas, reducing errors and accelerating development.

Core Features & Use Cases

  • Schema Definition and Conventions: Provides standardized naming conventions and best practices for database structures.
  • SQL Schema and Indexing: Contains example SQL scripts for creating tables, indexes, and triggers to ensure consistent database setup.
  • Migration Management: Offers guidance and script samples for executing reversible schema and data migrations using SQL and TypeScript, suitable for version control and deployment workflows.

Quick Start

Use the database migration scripts to create new tables and update existing schemas safely in your PostgreSQL database.

Frequently Asked Questions about ops-database

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

FAQPage Schema
How do I design a PostgreSQL database schema with proper indexing conventions?▼

PostgreSQL schema design is streamlined through standardized naming conventions and example SQL scripts for creating tables, indexes, and triggers. This Skill ensures consistent database setup and maintainable structural evolution.

What's the best way to manage reversible database migrations using SQL and TypeScript?▼

Database migration management is handled through guided script samples that execute reversible schema and data changes. By using SQL and TypeScript, migrations integrate smoothly into version control and deployment workflows.

Can I automate schema changes and data migrations for version control deployments?▼

Yes, automating schema changes is supported through provided migration scripts designed for version control integration. The scripts facilitate safe PostgreSQL schema updates and data migrations within structured deployment pipelines.

When do I need standardized database schema conventions for project maintainability?▼

Standardized schema conventions are needed when projects require reliable, maintainable database evolution workflows. Applying consistent naming and structural standards reduces errors and accelerates development across schema and data changes.

Does this database migration approach work for both schema updates and data migrations?▼

Yes, the migration approach works for both schema updates and data migrations. The provided SQL and TypeScript scripts offer reversible execution to safely manage structural changes and data transformations simultaneously.

Related Skills

Explore More Software Engineering Skills→
huydepzai121huydepzai121
3

postgresql-psql

Execute PostgreSQL psql commands for connections, queries, and administration.

Community
Intermediate
terrawareterraware
13

db-migration

Automate PostgreSQL migration file creation with SQL scripts and schema updates.

Official
Intermediate
dilipsundarraj1dilipsundarraj1
113

db-migration

Automate Flyway migrations for schema changes in Spring Boot Kafka consumer projects.

Community
Intermediate
inbharataiinbharatai
22

migration-generator

Generate up/down database migration scripts for Alembic, Flyway, and Liquibase.

Community
Intermediate