GoSQLX
Server Details
SQL validation, formatting, parsing, metadata extraction, linting, and security analysis.
- Status
- Healthy
- Last Tested
- Transport
- Streamable HTTP · MCP 2025-11-25
- URL
- Repository
- ajitpratap0/GoSQLX
- GitHub Stars
- 120
- Server Listing
- GoSQLX
TDQS
Score is being calculated.
Available Tools
7 toolsanalyze_sqlRead-onlyIdempotentInspect
Use this when the user wants a complete review of a SQL query. Runs validate, parse, metadata, security, lint, and format concurrently and returns one composite report; hosts that support MCP Apps render it as an interactive report.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to analyze |
extract_metadataRead-onlyIdempotentInspect
Use this when the user wants the tables, columns, and functions a SQL query references (e.g. for lineage or impact analysis). Returns {tables, columns, functions}.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to analyze |
format_sqlRead-onlyIdempotentInspect
Use this when the user wants SQL pretty-printed or reformatted: one clause per line, optional upper-case keywords and trailing semicolon. Comments are not kept. Returns {formatted_sql, options}.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to format | |
| indent_size | No | Spaces per indent level for nested blocks such as CREATE TABLE columns; clauses always start at column 0. 0 puts each statement on one line (default: 2) | |
| add_semicolon | No | Append a trailing semicolon (default: false) | |
| uppercase_keywords | No | true upper-cases all SQL keywords (AND, IN, CASE, ...), but not data type names. false keeps the formatter's casing: clause keywords (SELECT, FROM, WHERE, ...) upper-case, other keywords (e.g. and, or) may keep their input case (default: false) |
lint_sqlRead-onlyIdempotentInspect
Use this when the user wants SQL style feedback. Applies the same 10 rules as gosqlx lint: L001 trailing whitespace, L002 mixed indentation, L003 consecutive blank lines, L004 indentation depth, L005 line length (>100), L006 column alignment, L007 keyword case (upper), L008 comma placement (trailing), L009 aliasing consistency, L010 redundant whitespace. Returns {violation_count, violations}.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to lint |
parse_sqlRead-onlyIdempotentInspect
Use this when the user wants to know how SQL parses: returns an AST summary with the statement count and the type of each statement.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to parse |
security_scanRead-onlyIdempotentInspect
Use this when the user wants SQL checked for injection patterns: tautologies, UNION attacks, stacked queries, comment bypasses, and more. Returns findings with severity counts.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to scan |
validate_sqlRead-onlyIdempotentInspect
Use this when the user wants to know whether a SQL statement is syntactically valid, optionally for a specific dialect. Returns {valid: bool, error?: string, dialect?: string}.
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL string to validate | |
| dialect | No | SQL dialect: generic, postgresql, mysql, mariadb, sqlserver, oracle, sqlite, snowflake, bigquery, redshift, clickhouse |
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
7 tool updates
- First observed
analyze_sql - First observed
extract_metadata - First observed
format_sql - First observed
lint_sql - First observed
parse_sql - First observed
security_scan - First observed
validate_sql
Related MCP Connectors
Check SQL against your Vericto rules before it runs: blocks destructive or risky statements.
DBRE-grade SQL analysis inside any MCP client. No connection. No install. Paste a query.
Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.
Deterministic safety, correctness & cost gate that vets Postgres SQL before your AI agent runs it.
Related MCP Servers
- AlicenseAqualityDmaintenanceProvides SQL analysis, linting, and dialect conversion using SQLGlot, enabling validation, transpilation, and extraction of table/column references.432MIT
- AlicenseNot gradedqualityAmaintenanceDeterministic SQL static analysis and query-equivalence checking for Postgres, MySQL, SQLite, and SQL Server. Tokenizes locally before forwarding to the API.7Apache 2.0
- FlicenseNot gradedqualityDmaintenanceProvides SQL parsing, transpilation, formatting, extraction, and condition injection via MCP protocol, enabling agents to validate, analyze, and transform SQL.-
- AlicenseAqualityDmaintenanceEnables AI agents to format SQL, explain queries in plain English, analyze schemas, build queries from natural language, and generate migrations, all without requiring a database connection.529 npmMIT
Glama MCP Gateway
Add one secure layer between your agents and this server.