# GoSQLX MCP server

> Validate, parse, format, lint and security-scan SQL across 8 dialects without connecting to a database.

- Listing: https://mcp.tc/i/gosqlx
- Connect: use the server's own URL `https://mcp.gosqlx.dev/mcp` (no sign-in); clients connect to it directly. The listing link is a page, not an MCP endpoint.
- Type: remote (Streamable HTTP)
- Auth: none
- Category: [Developer Tools](https://mcp.tc/c/developer-tools)
- Vendor: ajitpratap0
- Homepage: <https://gosqlx.dev>
- Repository: <https://github.com/ajitpratap0/GoSQLX>

## About

GoSQLX is a Go SQL parser exposed as an MCP server. It validates, parses, formats, lints and scans SQL text for injection patterns, and extracts the tables, columns and functions a query references. Supported dialects include PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, Snowflake and ClickHouse.

All tools are read-only and deterministic. They never connect to a database or execute SQL. The server runs as a hosted Streamable HTTP endpoint, and no sign-in or API key is needed.

## What it can do

- Run a full review of a query in one call
- Check SQL syntax for a specific dialect
- Pretty-print SQL with optional upper-case keywords
- Lint SQL against style rules L001-L010
- Detect SQL injection patterns with severities
- Extract referenced tables, columns and functions
- Summarize statement count and types from the AST

## Tools (7)

- `analyze_sql`: Runs validation, parsing, metadata, security, lint and format checks and returns one report. (read-only)
- `extract_metadata`: Returns the tables, columns and functions a SQL query references. (read-only)
- `format_sql`: Pretty-prints SQL with options for keyword case, indent size and trailing semicolon. (read-only)
- `lint_sql`: Applies style rules L001-L010 and returns the violations. (read-only)
- `parse_sql`: Returns statement count and statement types, optionally for a dialect. (read-only)
- `security_scan`: Detects SQL injection patterns such as tautologies and UNION attacks, with severities. (read-only)
- `validate_sql`: Checks whether SQL is syntactically valid, optionally for a dialect. (read-only)

## Example prompts

- "Review this SQL query and tell me if anything looks wrong."
- "Is this statement valid PostgreSQL? SELECT \* FROM users WHERE id = 1;"
- "Format this SQL with upper-case keywords and a trailing semicolon."
- "Scan this query for SQL injection patterns."

## Install

### Claude Code

1. Run this in a terminal, in your project folder:

```bash
claude mcp add --transport http gosqlx https://mcp.gosqlx.dev/mcp
```

2. Start Claude Code and type `/mcp`. **gosqlx** should show as connected.

Add `--scope user` to make it available in every project, not just this one.

### Claude Desktop

1. Open **Customize → Connectors**, click **+ Add**, then **Add custom connector**.

2. Name it **GoSQLX** and paste this URL:

```url
https://mcp.gosqlx.dev/mcp
```

3. Click **Add**. Its tools appear in the chat’s tools menu.

Claude Desktop’s JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

### claude.ai

1. Open the connector form on claude.ai. This button fills in the name and URL for you:

[Add to claude.ai](<https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=GoSQLX&connectorUrl=https%3A%2F%2Fmcp.gosqlx.dev%2Fmcp>) (opens connector settings)

2. Check that the URL reads `https://mcp.gosqlx.dev/mcp` and click **Add**.

3. Turn it on in a chat from the tools menu.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under **Organization settings → Connectors**.

### ChatGPT

1. On chatgpt.com, go to **Plugins**, select **+**, then **Add custom MCP server**.

2. Enter a name for the server.

3. Under **Connection**, paste `https://mcp.gosqlx.dev/mcp` as the server URL, then for authentication choose **No authentication**.

4. Check **I understand and want to continue**, then select **Create as a plugin**.

Whether you can add a custom MCP server depends on your ChatGPT plan and your workspace permissions (in Business workspaces, admins and owners can).

### Cursor

[Add to Cursor](<https://cursor.com/install-mcp?name=gosqlx&config=eyJ1cmwiOiJodHRwczovL21jcC5nb3NxbHguZGV2L21jcCJ9>) (opens Cursor)

Or add it by hand to `~/.cursor/mcp.json` (all projects) or `.cursor/mcp.json` (this project):

`mcp.json`:

```json
{
  "mcpServers": {
    "gosqlx": {
      "url": "https://mcp.gosqlx.dev/mcp"
    }
  }
}
```

### VS Code

[Install in VS Code](<https://vscode.dev/redirect/mcp/install?name=gosqlx&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.gosqlx.dev%2Fmcp%22%7D>) (opens VS Code)

Or from a terminal:

```bash
code --add-mcp '{"name":"gosqlx","type":"http","url":"https://mcp.gosqlx.dev/mcp"}'
```

Or commit it to the repo in `.vscode/mcp.json`:

`.vscode/mcp.json`:

```json
{
  "servers": {
    "gosqlx": {
      "type": "http",
      "url": "https://mcp.gosqlx.dev/mcp"
    }
  }
}
```

### Devin Desktop

1. Add it to `~/.config/devin/mcp_config.json` (macOS and Linux) or `%APPDATA%\devin\mcp_config.json` (Windows):

`mcp_config.json`:

```json
{
  "mcpServers": {
    "gosqlx": {
      "serverUrl": "https://mcp.gosqlx.dev/mcp"
    }
  }
}
```

2. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf. It reads `serverUrl` (or `url`) for remote servers.

### Codex

```bash
codex mcp add gosqlx --url https://mcp.gosqlx.dev/mcp
```

Or edit `~/.codex/config.toml` directly:

`config.toml`:

```toml
[mcp_servers.gosqlx]
url = "https://mcp.gosqlx.dev/mcp"
```

### Gemini CLI

```bash
gemini mcp add --transport http gosqlx https://mcp.gosqlx.dev/mcp
```

This adds it to the current project. Add `-s user` to use it everywhere.

### Any client

Most clients accept this shape. Some name the URL field differently: `serverUrl` in Devin Desktop, `httpUrl` in Gemini CLI’s settings file.

```json
{
  "mcpServers": {
    "gosqlx": {
      "type": "http",
      "url": "https://mcp.gosqlx.dev/mcp"
    }
  }
}
```

Zed puts servers under `context_servers` in its settings. Cline needs `"type": "streamableHttp"`, or it assumes SSE.

Client only starts local servers? Bridge it with `npx -y mcp-remote https://mcp.gosqlx.dev/mcp`.

## Recent changes

- 2026-10-31 17:24 UTC: Tracking started: 7 tools read. Source: automatic check.

More on the History tab, with descriptions before and after for the newest entries: https://mcp.tc/i/gosqlx#history (Atom feed: https://mcp.tc/i/gosqlx/history.xml). It records what mcp.tc's anonymous checks saw, every 3 hours where the tool list can be read without sign-in; it is not a security review.

## Details

- Server version: 1.17.0
- MCP protocol version: 2025-11-25
- Last checked: 2026-11-18 (reachable)
- Listed: 2026-10-31
- Updated: 2026-10-31

---
Source: https://mcp.tc/i/gosqlx (mcp.tc is an independent directory, not affiliated with this server's publisher). Corrections: https://mcp.tc/report
