GoSQLX
Parse SQL at the speed of Go
๐ Try the Playground ยท ๐ Read the Docs ยท ๐ Get Started ยท ๐ Benchmarks
| 1.25M+ ops/sec | <1ฮผs latency | 85% SQL-99 | 6 dialects | 0 race conditions |
|---|
What is GoSQLX?
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 - handling 1.25M+ operations per second with sub-microsecond latency.
ast, _ := gosqlx.Parse("SELECT u.name, COUNT(*) FROM users u JOIN orders o ON u.id = o.user_id GROUP BY u.name")
// โ Full AST with statements, columns, joins, grouping - ready for analysis, transformation, or formatting
Why GoSQLX?
- Not an ORM - a parser. You get the AST, you decide what to do with it.
- Not slow - zero-copy tokenization, sync.Pool recycling, no allocations on hot paths.
- Not limited - PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake. CTEs, window functions, MERGE, set operations.
- Not just a library - CLI, VS Code extension, GitHub Action, MCP server, WASM playground, Python bindings.
Get Started in 60 Seconds
go get github.com/ajitpratap0/GoSQLX
package main
import (
"fmt"
"github.com/ajitpratap0/GoSQLX/pkg/gosqlx"
)
func main() {
// Parse any SQL dialect
ast, _ := gosqlx.Parse("SELECT * FROM users WHERE active = true")
fmt.Printf("%d statement(s)\n", len(ast.Statements))
// Format messy SQL
clean, _ := gosqlx.Format("select id,name from users where id=1", gosqlx.DefaultFormatOptions())
fmt.Println(clean)
// SELECT
// id,
// name
// FROM users
// WHERE id = 1
// Catch errors before production
if err := gosqlx.Validate("SELECT * FROM"); err != nil {
fmt.Println(err) // โ expected table name
}
}
Install Everywhere
๐ฆ Go Library๐ฅ๏ธ CLI Tool |
๐ป VS Code ExtensionBundles the binary - zero setup. Learn more โ ๐ค MCP Server (AI Integration)7 SQL tools in Claude, Cursor, or any MCP client. Guide โ |
Features at a Glance
โก ParserZero-copy tokenizerRecursive descent parserFull AST generationMulti-dialect engine |
๐ก๏ธ AnalysisSQL injection scanner10 lint rules (L001โL010)Query complexity scoringMetadata extraction |
๐ง ToolingAST-based formatterQuery transforms APIVS Code extensionGitHub Action |
๐ Multi-DialectPostgreSQL ยท MySQLSQL Server ยท OracleSQLite ยท Snowflake |
๐ค AI-ReadyMCP server (7 tools)Public remote endpointStreamable HTTP |
๐งช Battle-Tested20K+ concurrent opsZero race conditions~85% SQL-99 compliance |
Documentation
| Resource | Description | |
|---|---|---|
| ๐ | gosqlx.dev | Website with interactive playground |
| ๐ | Getting Started | Parse your first SQL in 5 minutes |
| ๐ | Usage Guide | Comprehensive patterns and examples |
| ๐ | API Reference | Complete API documentation |
| ๐ฅ๏ธ | CLI Guide | Command-line tool reference |
| ๐ | SQL Compatibility | Dialect support matrix |
| ๐ค | MCP Guide | AI assistant integration |
| ๐๏ธ | Architecture | System design deep-dive |
| ๐ | Benchmarks | Performance data and methodology |
| ๐ | Release Notes | What's new in each version |
Contributing
GoSQLX is built by contributors like you. Whether it's a bug fix, new feature, documentation improvement, or just a typo - every contribution matters.
git clone https://github.com/ajitpratap0/GoSQLX.git && cd GoSQLX
task check # fmt โ vet โ lint โ test (with race detection)
- Fork & branch from
main - Write tests - we use TDD and require race-free code
- Run
task check- must pass before PR - Open a PR - we review within 24 hours
๐ Contributing Guide ยท ๐ Code of Conduct ยท ๐๏ธ Governance
Community
License
Apache License 2.0 - see LICENSE for details.
Built with โค๏ธ by the GoSQLX community
gosqlx.dev ยท Playground ยท Docs ยท MCP Server ยท VS Code
If GoSQLX helps your project, consider giving it a โญ
