Skip to main content
Glama

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.

MCP client
Glama
MCP server

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.

100% free. Your data is private.
Tool DescriptionsA

Average 4/5 across 2 of 2 tools scored. Lowest: 3.2/5.

Server CoherenceA
Disambiguation5/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.

Naming Consistency5/5

Both tool names follow the consistent verb_noun pattern using snake_case: search_docs and view_skill. The naming convention is uniform and predictable.

Tool Count3/5

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.

Completeness2/5

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 tools
search_docsSearch DocumentationA
Read-onlyIdempotent
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitYesThe maximum number of matches to return. Defaults to 20.
queryYesThe search query. Used for BM25 when keyword or hybrid search applies, and for the embedding when semantic or hybrid search applies.
sourceYesThe 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.
semanticWeightYesControls 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

ParametersJSON Schema
NameRequiredDescription
resultsYes
Behavior5/5

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.

Conciseness5/5

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.

Completeness5/5

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.

Parameters4/5

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.

Purpose5/5

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.

Usage Guidelines4/5

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 SkillB
Read-onlyIdempotent
Inspect

Retrieve detailed skills for TimescaleDB operations and best practices.

Available Skills

ParametersJSON Schema
NameRequiredDescriptionDefault
pathYesA 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_nameYesThe name of the skill to browse, or `.` to list all available skills.

Output Schema

ParametersJSON Schema
NameRequiredDescription
contentYesThe content of the file or directory listing.
Behavior2/5

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.

Conciseness2/5

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.

Completeness4/5

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.

Parameters5/5

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.

Purpose4/5

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.

Usage Guidelines2/5

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.

Discussions

No comments yet. Be the first to start the discussion!

Related MCP Servers

  • A
    license
    -
    quality
    C
    maintenance
    Provides AI-powered PostgreSQL performance tuning capabilities including query analysis, smart index recommendations with HypoPG hypothetical testing, and comprehensive database health monitoring.
    Last updated
    25
    Apache 2.0
  • A
    license
    B
    quality
    D
    maintenance
    Enables 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 updated
    9
    MIT
  • A
    license
    A
    quality
    B
    maintenance
    Enables 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 updated
    34
    155
    MIT

View all MCP Servers

Try in Browser

Your Connectors

Sign in to create a connector for this server.