postgres-database-migration
timescale/pg-aiguideUse this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases.…
Scores out of 100 · grade A
2026-08-22Works
40% of the score100/100
- Loads cleanly: valid frontmatter, required fields present, no dangling references.
Maintained
25% of the score82/100
- no commits in the last 12 weeks
Adopted
20% of the score45/100
- 1,818 stars on the source repo.
Documented
15% of the score90/100
- 3,566 words with worked examples.
- Ships 3 bundled files.
Install
npx skills add timescale/pg-aiguide/postgres-database-migrationWhat it says it does
Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases. **Trigger when user asks to:** - Test a schema migration before applying it to production - Add, remove, or rename columns safely on a live table - Change a column's data type without downtime - Add or drop indexes, constraints, or foreign keys on large tables - Understand which ALTER TABLE operations lock the table - Roll back a failed migration - Plan a zero-downtime migration strategy - Fork a database to test a migration safely **Keywords:** migration, schema change, ALTER TABLE, add column, drop column, rename column, change type, zero downtime, lock, AccessExclusiveLock, concurrent index, forking, ghost, rollback, backfill, deploy Covers: lock-level reference for every common DDL operation, safe migration patterns, fork-based testing, zero-downtime column changes, index creation, constraint addition, backfill strategies, pre/post-migration validation, and rollback planning.
Also in timescale/pg-aiguide
| Artifact | Score | What the check found | Type | Reach | Last commit |
|---|---|---|---|---|---|
| design-postgis-tablestimescale/pg-aiguide | clean | Skill | 1.8k stars | 2 months ago | |
| design-postgres-tablestimescale/pg-aiguide | clean | Skill | 1.8k stars | 2 months ago | |
| find-hypertable-candidatestimescale/pg-aiguide | clean | Skill | 1.8k stars | 2 months ago | |
| ghost-databasetimescale/pg-aiguide | clean | Skill | 1.8k stars | 2 months ago | |
| migrate-postgres-tables-to-hypertablestimescale/pg-aiguide | clean | Skill | 1.8k stars | 2 months ago | |
| pgvector-semantic-searchtimescale/pg-aiguide | clean | Skill | 1.8k stars | 2 months ago |
Other ai & agents skills
Browse all| Artifact | Score | What the check found | Category | Reach | Last commit |
|---|---|---|---|---|---|
| mcp-builderanthropics/skills | No license | AI & agents | 104,949 installs | today | |
| agent-developmentanthropics/claude-plugins-official | clean | AI & agents | 5,901 installs | today | |
| plugin-settingsanthropics/claude-plugins-official | clean | AI & agents | 5,465 installs | today | |
| skill-creatoranthropics/claude-plugins-official | clean | AI & agents | 5,836 installs | today | |
| microsoft-foundrymicrosoft/azure-skills | clean | AI & agents | 544,819 installs | today | |
| claude-apianthropics/skills | No license | AI & agents | 59,236 installs | today |
Put this measurement in your README
A badge carrying how many listings this index holds from the repository and how many pass every static structural check. It reads from this index every time somebody loads your page, so it changes when the measurement changes and there is nothing to keep up to date. Free, no account, and the value is not something you or we can set by hand.
[](https://skillworks.kynth.studio/?q=timescale%2Fpg-aiguide)Would rather not hotlink us? Every badge is also served in shields.io’s endpoint schema, so shields renders the image and your readers never talk to our domain:
Published by Toolproof, the masthead over this index and eight others. The method behind the number is at toolproof.kynth.studio/methodology, and the whole thing is readable as JSON with no key at /api.
