migrate-postgres-tables-to-hypertables
🎯Skillfrom timescale/pg-aiguide
|Migrates existing PostgreSQL standard tables to TimescaleDB hypertables, automatically converting table schemas and data for time-series optimization.
Installation
npx skills add https://github.com/timescale/pg-aiguide --skill migrate-postgres-tables-to-hypertablesSkill Details
Overview
# pg-aiguide
AI-optimized PostgreSQL expertise for coding assistants
pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:
- Semantic search across the official PostgreSQL manual (version-aware)
- AI-optimized “skills” — curated, opinionated Postgres best practices used automatically by AI agents
- Extension ecosystem docs, starting with TimescaleDB, with more coming soon
Use it either as:
- a public MCP server that can be used with any AI coding agent, or
- a Claude Code plugin optimized for use with Claude's native skill support.
⭐ Why pg-aiguide?
AI coding tools often generate Postgres code that is:
- outdated
- missing constraints and indexes
- unaware of modern PG features
- inconsistent with real-world best practices
pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.
See the difference
https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d
Prompt given to Claude Code:
> Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.
Result (summarized):
- 4× more constraints
- 55% more indexes (including partial/expression indexes)
- PG17-recommended patterns
- Modern features (
GENERATED ALWAYS AS IDENTITY,NULLS NOT DISTINCT) - Cleaner naming & documentation
Conclusion: _pg-aiguide produces more robust, performant, maintainable schemas._
🚀 Quickstart
pg-aiguide is available as a public MCP server:
[https://mcp.tigerdata.com/docs](https://mcp.tigerdata.com/docs)
```json
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
```
Or it can be used as a Claude Code Plugin:
```bash
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
```
Install by environment
#### One-click installs
[](https://cursor.com/en/install-mcp?name=pg-aiguide&config=eyJuYW1lIjoicGctYWlndWlkZSIsInR5cGUiOiJodHRwIiwidXJsIjoiaHR0cHM6Ly9tY3AudGlnZXJkYXRhLmNvbS9kb2NzIn0=)
[](https://vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)
[](https://insiders.vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D&quality=insiders)
[](https://vs-open.link/mcp-install?%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)
[](https://block.github.io/goose/extension?cmd=&arg=&id=pg-aiguide&name=pg-aiguide&description=MCP%20Server%20for%20pg-aiguide)
[](https://lmstudio.ai/install-mcp?name=pg-aiguide&config=eyJuYW1lIjoicGctYWlndWlkZSIsInR5cGUiOiJodHRwIiwidXJsIjoiaHR0cHM6Ly9tY3AudGlnZXJk
More from this repository5
Enhances AI coding tools with intelligent, version-aware PostgreSQL code generation, providing semantic search and best practice recommendations for database schemas and queries.
Generates high-quality, performant PostgreSQL table schemas with best practices, constraints, and modern Postgres features automatically.
Configures TimescaleDB hypertables with optimized schema design, automatically generating best-practice partitioning and indexing strategies for time-series data.
Identifies potential database tables suitable for conversion to TimescaleDB hypertables based on time-series data characteristics and usage patterns.
Enhances Claude's PostgreSQL code generation by providing semantic search, best practices, and version-aware expertise for creating more robust and performant database schemas.