io.github.ajitpratap0由 GitHub 账号 ajitpratap0 发布v1.17.0更新于 Oct 31, 2026
SQL validation, formatting, parsing, metadata extraction, linting, and security analysis.
远程 MCP 服务器，让助手在不连接数据库的情况下校验、格式化、解析、检查风格并扫描 SQL 注入风险，支持八种方言。
Web executable，通过 Streamable HTTP。 远程服务在工作区中配置后即可从网页运行时运行。
把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体，或 SourceWeft 对话中。智能体会读取该服务器的安装指南，先向你展示发布者、端点和登录方式，经你同意后再把它添加到你的客户端。密钥不会写进任何命令。
阅读 https://sourceweft.com/mcp/io.github.ajitpratap0%2Fgosqlx/install.md，并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前，先告诉我它的发布者、端点和登录方式，等我确认。不要把 API 密钥写进命令或我会提交的文件；问我密钥应从哪里获取。把它添加到你客户端的 mcpServers 配置中。
{
"mcpServers": {
"gosqlx": {
"type": "http",
"url": "https://mcp.gosqlx.dev/mcp"
}
}
}Pure-Go SQL parser, formatter, linter and security scanner for 8 dialects.
[CI] [Go Reference] [Release] [License] [OpenSSF Scorecard]
Playground · Docs · Benchmarks · VS Code · MCP server
† Parse stage only (pre-tokenized input to AST), SELECT id, name FROM users, Apple M4, Go 1.27, median of 20 runs of BenchmarkPerformanceBaseline. Complex queries take longer (see performance_baselines.json). Reproduce: go test -run ^$ -bench BenchmarkPerformanceBaseline -benchmem -count=20 ./pkg/sql/parser/.
GoSQLX is a production-ready SQL parsing SDK for Go. It tokenizes, parses, and generates ASTs from SQL with zero-copy optimizations and intelligent object pooling - parsing a simple SELECT in about 363 ns (~2.8M parses/sec).
The extension bundles the binary, so there is no extra setup. Learn more.
7 SQL tools in Claude, Cursor, or any MCP client. MCP guide.
Claude Code plugin (skills, slash commands, SQL reviewer agent): /plugin marketplace add ajitpratap0/GoSQLX then /plugin install gosqlx@gosqlx - details.
ChatGPT app: add https://mcp.gosqlx.dev/mcp as a connector in developer mode for an interactive analysis widget - details.
Source: examples/readme_quickstart/main.go, compiled in CI against HEAD and the latest release.
Output:
Formatting turns one-line SQL into a readable query:
[Before: one-line lowercase SQL. After gosqlx format: SELECT, FROM, INNER JOIN, WHERE, GROUP BY, HAVING, ORDER BY and LIMIT each on their own line]gosqlx highlight query.sql or gosqlx.HighlightANSI(sql).--dialect flag and WithDialect accept 11 names: those 8 (postgresql, mysql, mariadb, sqlserver, oracle, sqlite, snowflake, clickhouse) plus generic, bigquery and redshift. BigQuery and Redshift have no dialect-specific keyword set (they use the generic keywords) and only capability-gated grammar, such as BigQuery's QUALIFY, PIVOT/UNPIVOT, UNNEST in FROM and (struct).field access.GoSQLX is built by contributors like you. Whether it's a bug fix, new feature, documentation improvement, or just a typo - every contribution matters.
maintask check - must pass before PRContributing Guide · Code of Conduct · Governance
Questions or ideas: Discussions. Found a bug or want a feature: Issues.
Apache License 2.0 - see LICENSE for details.
gosqlx.dev · Playground · Docs · MCP Server · VS Code
来源：README.md，提交 271e15e
Analyze SQL
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.
sql必填Extract SQL metadata
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}.
sql必填Format SQL
Use this when the user wants SQL pretty-printed or reformatted: one clause per line, optional upper-case keywords and trailing semicolon. Comments are preserved; unplaceable optimizer hints are refused. Returns {formatted_sql, options}.
sql必填indent_sizeadd_semicolonuppercase_keywordsLint SQL
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}.
sql必填Parse SQL
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, optionally for a specific dialect. GO batch separators are excluded from the count.
sql必填dialectScan SQL for injection
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.
sql必填Validate SQL
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}.
sql必填dialect已满足适用检查项的 100%
该评分衡量此收录条目的完整程度，依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价，也不表示服务器安全或当前可用：可连通性是带日期的检查结果，评分也不包含安装量或用户评价。
go get github.com/ajitpratap0/GoSQLXgo install github.com/ajitpratap0/GoSQLX/cmd/gosqlx@latestcode --install-extension ajitpratap0.gosqlxclaude mcp add --transport http gosqlx https://mcp.gosqlx.dev/mcp- uses: ajitpratap0/GoSQLX@v1 with: files: '**/*.sql' validate: truepackage main
import ( "context" "errors" "fmt" "log"
"github.com/ajitpratap0/GoSQLX/pkg/gosqlx" "github.com/ajitpratap0/GoSQLX/pkg/sql/ast")
func main() { ctx := context.Background()
// ParseTree is the recommended entry point. It returns an // opaque handle with built-in helpers. tree, err := gosqlx.ParseTree(ctx, "SELECT id, name FROM users WHERE active = true", gosqlx.WithDialect("postgresql")) if err != nil { // Sentinel errors work with errors.Is if errors.Is(err, gosqlx.ErrSyntax) { log.Fatalf("syntax error: %v", err) } log.Fatal(err) } fmt.Println("Tables:", tree.Tables()) fmt.Println(tree.Format(gosqlx.WithIndent(2), gosqlx.WithUppercaseKeywords(true)))
// Walk the AST - typed walkers avoid the type-assertion dance: tree.WalkSelects(func(s *ast.SelectStatement) bool { fmt.Printf(" SELECT with %d columns\n", len(s.Columns)) return true })
// The legacy Parse/Format/Validate API still works for v1.x code. // See docs/MIGRATION.md for the Tree migration guide.}Tables: [users]SELECT id, nameFROM usersWHERE active = true SELECT with 2 columnsgit clone https://github.com/ajitpratap0/GoSQLX.git && cd GoSQLXtask check # fmt → vet → lint → test (with race detection)