pg-aiguide
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,803
- Server Listing
- pg-aiguide
Glama MCP Gateway
Connect through Glama MCP Gateway for full control over tool access and complete visibility into every call.
Full call logging
Every tool call is logged with complete inputs and outputs, so you can debug issues and audit what your agents are doing.
Tool access control
Enable or disable individual tools per connector, so you decide what your agents can and cannot do.
Managed credentials
Glama handles OAuth flows, token storage, and automatic rotation, so credentials never expire on your clients.
Usage analytics
See which tools your agents call, how often, and when, so you can understand usage patterns and catch anomalies.
Tool Definition Quality
Average 4/5 across 2 of 2 tools scored. Lowest: 3.2/5.
The two tools have clearly distinct purposes: search_docs searches documentation, while view_skill retrieves a specific skill's details. There is no overlap in their actions or resources, so an agent can easily choose between them.
Both tool names follow the consistent verb_noun pattern using snake_case: search_docs and view_skill. The naming convention is uniform and predictable.
With only two tools, the set is minimal but could be sufficient for a documentation/skill guide. However, it feels thin given the breadth of topics covered by the available skills, and a listing tool would make the count more robust.
The server lacks a way to discover available skills; view_skill requires knowing the skill name in advance, and there is no list_skills or index tool. This creates a significant gap that will cause agents to fail when they don't know what skills exist, undermining the guide's usability.
Available Tools
2 toolssearch_docsSearch DocumentationARead-onlyIdempotentInspect
Search documentation with hybrid semantic (vector) and keyword (BM25) search. Use semanticWeight to choose keyword-only (0), semantic-only (1), or a blend; mid values fuse rankings with RRF. Supports Tiger Cloud (TimescaleDB), PostgreSQL, and PostGIS.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | Yes | The maximum number of matches to return. Defaults to 20. | |
| query | Yes | The search query. Used for BM25 when keyword or hybrid search applies, and for the embedding when semantic or hybrid search applies. | |
| source | Yes | The documentation source to search. "tiger" for Tiger Cloud and TimescaleDB, "postgres" for PostgreSQL, "postgis" for PostGIS spatial extension. Specific versions provided with _X.X suffixes. | |
| semanticWeight | Yes | Controls the balance between semantic and keyword search. 0 = keyword only, 0.5 = equal mix, 1 = semantic only. Default is 0.7 (favor semantic search). |
Output Schema
| Name | Required | Description |
|---|---|---|
| results | Yes |
Tool Definition Quality
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Beyond the annotations (readOnly, idempotent), the description discloses the hybrid search mechanism, BM25, semantic vectors, RRF fusion for mid values, and supported database platforms. This adds substantial behavioral context without contradicting annotations.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is two sentences, front-loaded with the core purpose, and every piece of information earns its place. No fluff or redundancy.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the presence of an output schema and detailed annotations, the description sufficiently covers the tool's functionality, parameter tuning, and supported sources. It does not need to detail return values since the output schema exists.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema already covers all parameters, but the description adds meaning by explaining the semanticWeight scale and that query is used for both BM25 and embedding where relevant. This goes beyond simple parameter names.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool searches documentation using hybrid semantic and keyword search, which is a specific verb+resource combination. It also distinguishes from the sibling tool view_skill by focusing on search rather than viewing.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides explicit guidance on using semanticWeight values (0, 1, blend) and lists supported sources. However, it does not explicitly contrast with view_skill or state when not to use this tool, so it lacks full alternative guidance.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
view_skillView SkillBRead-onlyIdempotentInspect
Retrieve detailed skills for TimescaleDB operations and best practices.
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. |
Output Schema
| Name | Required | Description |
|---|---|---|
| content | Yes | The content of the file or directory listing. |
Tool Definition Quality
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
The annotations already declare readOnlyHint=true and idempotentHint=true, which informs the agent that this is a safe, read-only operation. However, the description adds no behavioral detail beyond that—it does not mention how the tool returns skill contents (e.g., file text, directory listings), error cases, or any other side effects. The massive skill list is reference data, not behavior disclosure.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely long, dominated by the available_skills list. While the list is useful, it is not concise and pushes the actual tool purpose statement to the periphery. The phrase "Retrieve detailed skills..." is front-loaded, but the list becomes noise for an agent that just needs to know how to invoke the tool. The instruction that every sentence should earn its place is violated by the sheer volume of repetitive skill descriptions.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a read-only browsing tool, the description is largely complete: the schema covers both parameters, the output schema presumably describes return values, and the available skills list gives comprehensive context for valid skill_name values. The only gap is the misleading "TimescaleDB operations" scope, which is corrected by the list itself, and the lack of guidance for distinguishing this tool from search_docs. Overall, the tool is well-specified despite the verbosity.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema provides descriptions for both parameters (100% coverage), but the description adds substantial value by enumerating all valid skill names with their descriptions and trigger conditions. This effectively serves as an inline enum for skill_name, far exceeding the schema's generic "name of the skill to browse". The path parameter is already well-described in the schema, and the description does not detract from that.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's action: "Retrieve detailed skills for TimescaleDB operations and best practices." This is a specific verb+resource, but the qualifier "for TimescaleDB" is slightly misleading since the available skills cover general PostgreSQL, PostGIS, pgvector, and other topics. The tool's name and title further clarify its intent, and the extensive skill list provides concrete examples of what it can retrieve.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description does not explicitly state when to use this tool versus alternatives like search_docs. There is no guidance on when to prefer viewing a skill versus searching documentation, nor any exclusions or prerequisites. The available skills list contains each skill's "Trigger when user asks to" sections, but those are usage guidelines for the skill content, not for the view_skill tool itself.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
Claim this connector by publishing a /.well-known/glama.json file on your server's domain with the following structure:
{
"$schema": "https://glama.ai/mcp/schemas/connector.json",
"maintainers": [{ "email": "your-email@example.com" }]
}The email address must match the email associated with your Glama account. Once published, Glama will automatically detect and verify the file within a few minutes.
Control your server's listing on Glama, including description and metadata
Access analytics and receive server usage reports
Get monitoring and health status updates for your server
Feature your server to boost visibility and reach more users
For users:
Full audit trail – every tool call is logged with inputs and outputs for compliance and debugging
Granular tool control – enable or disable individual tools per connector to limit what your AI agents can do
Centralized credential management – store and rotate API keys and OAuth tokens in one place
Change alerts – get notified when a connector changes its schema, adds or removes tools, or updates tool definitions, so nothing breaks silently
For server owners:
Proven adoption – public usage metrics on your listing show real-world traction and build trust with prospective users
Tool-level analytics – see which tools are being used most, helping you prioritize development and documentation
Direct user feedback – users can report issues and suggest improvements through the listing, giving you a channel you would not have otherwise
The connector status is unhealthy when Glama is unable to successfully connect to the server. This can happen for several reasons:
The server is experiencing an outage
The URL of the server is wrong
Credentials required to access the server are missing or invalid
If you are the owner of this MCP connector and would like to make modifications to the listing, including providing test credentials for accessing the server, please contact support@glama.ai.
Discussions
No comments yet. Be the first to start the discussion!
Related MCP Servers
- Alicense-qualityFmaintenanceEnables AI assistants to manage, monitor, and optimize PostgreSQL databases with over 200 specialized tools for operations, security, performance tuning, and diagnostics.Last updated377MIT
- Alicense-qualityCmaintenanceProvides AI-powered PostgreSQL performance tuning capabilities including query analysis, smart index recommendations with HypoPG hypothetical testing, and comprehensive database health monitoring.Last updated25Apache 2.0
- AlicenseBqualityDmaintenanceEnables comprehensive PostgreSQL database management including index tuning, query plan analysis, health monitoring, schema-aware SQL generation, and safe SQL execution with configurable access control for both development and production environments.Last updated9MIT
- AlicenseAqualityBmaintenanceEnables comprehensive PostgreSQL database monitoring, analysis, and management through natural language queries. Provides performance insights, bloat analysis, vacuum monitoring, and intelligent maintenance recommendations across PostgreSQL versions 12-17.Last updated34155MIT
Your Connectors
Sign in to create a connector for this server.