GoSQLX is a read-only SQL analysis server offering 7 tools for working with SQL queries across multiple dialects (generic, mysql, postgresql, sqlite, sqlserver, oracle, snowflake):

• analyze_sql: Run all 6 analysis tools concurrently and return a single composite report.

• validate_sql: Check SQL syntax correctness with optional dialect-specific validation.

• parse_sql: Parse SQL and return an AST summary including statement count and types.

• extract_metadata: Extract referenced tables, columns, and functions from SQL.

• format_sql: Reformat SQL with configurable indent size, trailing semicolon, and keyword casing.

• lint_sql: Apply up to 10 style rules (L001–L010) to catch style and quality issues.

• security_scan: Detect SQL injection patterns such as tautologies, UNION attacks, stacked queries, and comment bypasses.

Enables parsing, formatting, validation, and analysis of MySQL SQL queries, providing tools for linting, metadata extraction, and identifying potential security vulnerabilities.

Enables parsing, formatting, validation, and analysis of PostgreSQL SQL queries, providing tools for linting, metadata extraction, and identifying potential security vulnerabilities.

Enables parsing, formatting, validation, and analysis of Snowflake SQL queries, providing tools for linting, metadata extraction, and identifying potential security vulnerabilities.

Enables parsing, formatting, validation, and analysis of SQLite SQL queries, providing tools for linting, metadata extraction, and identifying potential security vulnerabilities.

// v1.15+ recommended entry point: ParseTree returns an opaque Tree,
// so you don't need to import pkg/sql/ast just to get started.
tree, _ := gosqlx.ParseTree(ctx, "SELECT u.name, COUNT(*) FROM users u JOIN orders o ON u.id = o.user_id GROUP BY u.name",
 gosqlx.WithDialect("postgresql"))
fmt.Println("Tables:", tree.Tables())
fmt.Println(tree.Format(gosqlx.WithIndent(2), gosqlx.WithUppercaseKeywords(true)))

go get github.com/ajitpratap0/GoSQLX

package main

import (
 "fmt"
 "github.com/ajitpratap0/GoSQLX/pkg/gosqlx"
)

func main() {
 ctx := context.Background()

 // ParseTree (v1.15+) is the recommended entry point. It returns an
 // opaque handle with built-in helpers — no need to import pkg/sql/ast.
 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.
}

go get github.com/ajitpratap0/GoSQLX

go install github.com/ajitpratap0/GoSQLX/cmd/gosqlx@latest
gosqlx validate "SELECT * FROM users"
gosqlx format query.sql
gosqlx lint query.sql

code --install-extension ajitpratap0.gosqlx

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

git clone https://github.com/ajitpratap0/GoSQLX.git && cd GoSQLX
task check # fmt → vet → lint → test (with race detection)