🐘
DevOpsPython

PostgreSQL Database Migration

by timescale

PostgreSQL Database Migration is a DevOps skill for Claude Code, published by timescale in pg-aiguide.

1.8K stars104 forkson timescale/pg-aiguideAdded 2026/08/18Repository updated 2026/06/26
aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills
Install in seconds
Install PostgreSQL Database Migration
Copy PostgreSQL Database Migration into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/timescale/pg-aiguide/tree/main/skills/postgres-database-migration ~/.claude/skills/postgres-database-migration

Requires Node.js. Downloads this skill only β€” not the rest of the repository β€” into your Claude Code skills folder.

Without Node.js

git clone https://github.com/timescale/pg-aiguide.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
skills/postgres-database-migration/SKILL.md in timescale/pg-aiguide
Installs to
~/.claude/skills/postgres-database-migration
Collection
One of 10 skills cataloged from this repository
Category
DevOps β€” 798 skills

What PostgreSQL Database Migration does

PostgreSQL Database Migration helps plan, test, and safely execute PostgreSQL schema migrations on production data. Use it to understand DDL lock levels, perform zero-downtime ALTER TABLE changes, backfill data, and plan rollbacks.

PostgreSQL Database Migration is cataloged under DevOps on DirSkills. PostgreSQL Database Migration comes from a repository tagged ai, ai-agents, ai-coding, claude-code-plugin and claude-code-plugins.

Documentation

README

PostgreSQL Database Migrations

A schema migration that works on an empty dev database can fail, lock, or corrupt data on a production table with millions of rows. This guide covers how to assess risk, test against real data, and execute migrations safely.

DDL Lock Reference

Every schema change acquires a lock. The critical question is: does it block reads and writes, and for how long?

Fast, Non-Blocking Operations

These complete in milliseconds regardless of table size. They only hold a brief AccessExclusiveLock for the catalog update, not for data rewriting.

This is the opening of the README. Read the full README on GitHub.

Frequently asked about PostgreSQL Database Migration

  • What else does timescale publish alongside PostgreSQL Database Migration?

    PostgreSQL Database Migration is one of 10 skills that DirSkills catalogs from timescale/pg-aiguide, the repository it ships in. Its siblings there include Find Hypertable Candidates, Ghost Database and PGVector Semantic Search. Each one is a separate skill with its own page in this directory, installs the same way PostgreSQL Database Migration does, and is maintained by timescale in that same repository. The rest of the collection is listed on the timescale/pg-aiguide page.

  • How does PostgreSQL Database Migration compare to other DevOps skills?

    PostgreSQL Database Migration ranks #290 by stars among the 798 DevOps skills in this catalog. The most-starred ones next to it are Backend Patterns, API Connector Builder and Migration. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of PostgreSQL Database Migration against them. Open each page to compare what they document and how they install.

More from timescale/pg-aiguide

PostgreSQL Database Migration is one of 10 skills cataloged on DirSkills from timescale/pg-aiguide.

See all 10 skills β†’
πŸ—„οΈ
2w ago

Find Hypertable Candidates

Find Hypertable Candidates analyzes an existing PostgreSQL database to identify which tables should be converted to Timescale/TimescaleDB hypertables. Use it when auditing tables for time-series or insert-heavy workloads and evaluating hypertable candidacy before migration.
DevOps
1.8K104
🐘
2w ago

Ghost Database

Ghost Database creates and manages PostgreSQL databases for agent workflows, with on-demand creation, instant forks for safe testing, and shareable snapshots. Use it when an agent needs persistent storage or wants to pass databases as assets between workflows.
DevOps
1.8K104
πŸ”
2w ago

PGVector Semantic Search

PGVector Semantic Search stores and searches vector embeddings in PostgreSQL using HNSW or IVFFlat indexes for semantic search, RAG, and nearest-neighbor queries. Use it to set up pgvector, tune recall and performance, or implement binary quantization for large datasets.
AI Engineering
1.8K104
πŸ—ΊοΈ
2w ago

PostGIS Spatial Table Design

PostGIS Spatial Table Design provides best practices and SQL patterns for designing PostGIS tables, covering geometry types, SRID selection, spatial indexes, and performance considerations for location-based applications.
Data
1.8K104
🐘
2w ago

PostgreSQL

PostgreSQL provides expert guidance for PostgreSQL table design, indexing, data types, constraints, extensions, search, and migrations. Use it when designing schemas, working with pgvector/PostGIS/TimescaleDB, or planning safe schema changes.
Data
1.8K104
🐘
2w ago

PostgreSQL Table Design

PostgreSQL Table Design guides PostgreSQL schema, table, data type, constraint, and index decisions when creating new tables or modifying existing ones.
Data
1.8K104