Skip to main content
Glama
j4c0bs

mcp-server-sql-analyzer

by j4c0bs

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
lint_sqlB
Lint SQL query and return syntax errors

Some syntax errors are not detected by the parser like trailing commas

Args:
    sql: SQL query to analyze
    dialect: Optional SQL dialect (e.g., 'mysql', 'postgres')

Returns:
    error message or "No syntax errors" if parsing succeeds
transpile_sqlA
Transpile SQL statement to another dialect

Args:
    sql: SQL statement to transpile
    read_dialect: SQL dialect to read from
    write_dialect: SQL dialect to write to

Returns:
    transpiled SQL or syntax error
get_all_table_referencesA
Extract table and CTE names from SQL statement

Args:
    sql: SQL statement to analyze
    dialect: Optional SQL dialect (e.g., 'mysql', 'postgres')
Returns:
    JSON object containing tables with catalog, database, and alias attributes
    CTEs are returned as "cte" type
get_all_column_referencesA
Extract column references from SQL statement with table context

Args:
    sql: SQL statement to analyze
    dialect: Optional SQL dialect (e.g., 'mysql', 'postgres')
Returns:
    JSON object containing column references with table context and any errors

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription
dialects://all

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/j4c0bs/mcp-server-sql-analyzer'

If you have feedback or need assistance with the MCP directory API, please join our Discord server