Enhance Go database operations with JSON handling, SQL hooks, and automatic rebind.
npx skills add https://github.com/go-sqlex/sqlex --skill sqlex
Please help me install this Agent Skill. Skill: sqlex Source: https://github.com/go-sqlex/sqlex/tree/main Command: npx skills add https://github.com/go-sqlex/sqlex --skill sqlex
sqlex simplifies Go database operations, providing advanced features like structured JSON types, Hook aspects for logging and metrics, and automatic rebind for easier SQL injection prevention.
db.Get(&user, "SELECT * FROM users WHERE id = ?", 1) which will work across PostgreSQL, MySQL, SQLite, and SQL Server without needing to change the query syntax.Use sqlex to connect to your database and execute queries:
db, err := sqlex.Connect("sqlite3", ":memory:")
if err != nil {
log.Fatal(err)
}
defer db.Close()
// Insert a user
_, err = db.Exec("INSERT INTO users (name, email) VALUES (?, ?)", "Alice", "[email protected]")
if err != nil {
log.Fatal(err)
}
// Query a user
var user User
err = db.Get(&user, "SELECT * FROM users WHERE id = ?", 1)
if err != nil {
log.Fatal(err)
}
fmt.Printf("User: %+v\n", user)
High-intent search queries and answers about installing and using this skill.
Go database operations can handle JSON columns automatically using generic JSONValue[T] types to auto-serialize and deserialize JSON data directly into structs during query execution.
Yes, automatic rebind writes ? uniformly across PostgreSQL, MySQL, SQLite, and SQL Server, translating placeholders automatically to prevent SQL injection without changing query syntax.
Adding logging and metrics to Go SQL execution is best done with pluggable Hook interceptors, which monitor query execution for tracing and performance tracking without altering core logic.
Yes, you need the sqlex library dependency to use generic JSONValue[T] types, SQL execution hooks, and automatic rebind features for robust Go database operations.
Connect to SQLite in Go using sqlex.Connect("sqlite3", ":memory:"), then execute db.Get or db.Exec queries to insert and retrieve structured records seamlessly.
go-againSelect the query or ORM front-end in the LiteORM Go database library.
swaruplabQuery Open Targets Platform GraphQL API for target-disease associations, evidence, and drugs.
ozan-fnConfigure structured logging, metrics, tracing, and profiling for Go services.
berksunduriGuide Go database interactions with parameterized queries and transaction management.