Server Details
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
- Status
- Healthy
- Last Tested
- Transport
- Streamable HTTP
- URL
- Repository
- timescale/pg-aiguide
- GitHub Stars
- 1,439
Available Tools
2 toolssearch_docsTry in Inspector
Search documentation using semantic or keyword search. Supports Tiger Cloud (TimescaleDB) and PostgreSQL.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | Yes | The maximum number of matches to return. Default is 10. | |
| query | Yes | The search query. For semantic search, use natural language. For keyword search, provide keywords. | |
| source | Yes | The documentation source to search. "tiger" for Tiger Cloud and TimescaleDB, "postgres" for PostgreSQL. | |
| version | Yes | The PostgreSQL major version (ignored when searching "tiger"). Recommended to assume the latest version if unknown. | |
| search_type | Yes | The type of search to perform. "semantic" uses natural language vector similarity, "keyword" uses BM25 keyword matching. |
view_skillTry in Inspector
Retrieve detailed skills for TimescaleDB operations and best practices.
Available Skills
<available_skills> [6 ]{name description}: design-postgres-tables Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features find-hypertable-candidates Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables migrate-postgres-tables-to-hypertables Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation pgvector-semantic-search pgvector setup and best practices for semantic search with text embeddings in PostgreSQL postgres-hybrid-text-search Hybrid search in PostgreSQL combining BM25 keyword search (pg_textsearch) with semantic search (pgvector) using RRF fusion setup-timescaledb-hypertables "Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting: partition columns, segment_by columns, order_by columns, chunk time interval, real-time aggregation." </available_skills>
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | A relative path to a file or directory within the skill to view. If empty, will view the `SKILL.md` file by default. Use `.` to list the root directory of the skill. | |
| skill_name | Yes | The name of the skill to browse, or `.` to list all available skills. |
FAQ
How do I claim this server?
To claim this server, publish a /.well-known/glama.json file on your server's domain with the following structure:
The email address must match the email associated with your Glama account. Once verified, the server will appear as claimed by you.
What are the benefits of claiming a server?
- Control your server's listing on Glama, including description and metadata
- Receive usage reports showing how your server is being used
- Get monitoring and health status updates for your server
Your Connectors
Sign in to create a connector for this server.