Timescale Postgres AI Guide
Timescale official MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding agents write better Postgres queries. 1,718 GitHub stars and 2 commits on main in the last 30 days.
“Timescale official MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding agents write better Postgres queries. 1,718 stars and 2 commits on main in the last 30 days.”
INSTALL THIS SERVER
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@timescale/pg-aiguide"
],
"env": {
"PG_CONNECTION_STRING": "postgres://user:pass@host:5432/db"
}
}
}
}
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@timescale/pg-aiguide"
],
"env": {
"PG_CONNECTION_STRING": "postgres://user:pass@host:5432/db"
}
}
}
}
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@timescale/pg-aiguide"
],
"env": {
"PG_CONNECTION_STRING": "postgres://user:pass@host:5432/db"
}
}
}
}
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@timescale/pg-aiguide"
],
"env": {
"PG_CONNECTION_STRING": "postgres://user:pass@host:5432/db"
}
}
}
}
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@timescale/pg-aiguide"
],
"env": {
"PG_CONNECTION_STRING": "postgres://user:pass@host:5432/db"
}
}
}
}
5 TOOLS AVAILABLE
OUR ASSESSMENT
- Timescale official maintenance.
- 1,718 GitHub stars.
- 2 commits on main in the last 30 days.
- Apache-2.0 license.
- Skills-and-docs scope rather than raw SQL execution.
- Curated guidance from the Timescale team.
- Postgres/TimescaleDB-specific; non-Postgres use cases find no value.
- Skills coverage depends on Timescale catalog updates.
- Live-database tools require a PG_CONNECTION_STRING; doc tools alone work without a database.
PG_CONNECTION_STRING grants the connecting role permissions to the database. Use a read-only role for analyse/explain workloads. Documentation tools require no database connection and carry no DB-side risk.
AI coding agents writing Postgres queries who need expert-level guidance; TimescaleDB users who want their Claude/Cursor agent to ground in current Timescale docs; teams new to Postgres who want their agent to surface idioms and pitfalls.
TECHNICAL DETAILS
ADOPTION METRICS
// Reading this1,718 stars on timescale/pg-aiguide. 2 commits on main in the last 30 days.
// Reading thisPairs with postgres-mcp, mongodb-mcp, neon-mcp, supabase, planetscale-mcp, MCP Toolbox for Databases, dbhub-mcp in database. Timescale's pg-aiguide owns the Postgres-skills slot.
SOURCES & VERIFICATION
We don't take any single directory's word for it. Before scoring, we cross-reference 5 public MCP sources, install the server ourselves against the clients we cover, and record when we last re-verified.
The same server, 5 different lenses. We reconcile these signals into our editorial score, which is why our number sometimes diverges from a directory-aggregate star count.
| Source | Their rating | Their star count | Their downloads | Last synced |
|---|---|---|---|---|
| AutomationSwitch This page | 4.4editorial | 1,718 | — | MAY 9, 2026 |
| PulseMCP | — unrated | unavailable | unavailable | MAY 9, 2026 |
| MCP.so | — unrated | unavailable | unavailable | MAY 9, 2026 |
| Glama | — unrated | unavailable | unavailable | MAY 9, 2026 |
| Smithery | — unrated | unavailable | unavailable | MAY 9, 2026 |
| Official MCP Registry | — unrated | unavailable | unavailable | MAY 9, 2026 |
// Counts are directory-reported; we don't adjust them. Discrepancies usually come from different snapshot times or star-caching.
OTHER DATABASE MCP SERVERS
Postgres MCP
Official MCP server for PostgreSQL. Provides read and write access to PostgreSQL databases with schema introspection, query execution, and transaction support. The reference implementation for database MCP servers.
Supabase
Persistence layer with full Postgres access and Row Level Security awareness. Query tables, manage schemas, handle auth users, and work with storage buckets.
MCP Toolbox for Databases
Google's open-source MCP server for databases. One MCP binary speaks PostgreSQL, MySQL, BigQuery, Spanner, AlloyDB, Cloud SQL, and SQLite. 14,937 GitHub stars and 100 commits on main in the last 30 days. Highest commit cadence in the directory.
ClickHouse MCP
Official ClickHouse MCP server with both ClickHouse Tools (production cluster queries) and chDB Tools (embedded ClickHouse for local analytics). Apache-2.0 with destructive-operation protection: write access is opt-in via configuration.
DBHub
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, and SQLite. Maintained by Bytebase. 2,717 GitHub stars and 3 commits on main in the last 30 days.
Redis MCP
Official Redis MCP server with natural-language interface for managing and searching Redis data. EntraID authentication for Azure Managed Redis included; Redis ACL configurable via environment variables. Tool coverage spans strings, lists, hashes, sets, sorted sets, JSON, vectors, and search.
DISCUSS YOUR
MCP REQUIREMENTS.
Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.