Open Source Go SQL Clients

Cloud SQL Proxy is a secure connectivity utility that enables applications to connect to Google Cloud SQL instances without requiring manual configuration of SSL certificates or network access rules. It works by establishing an encrypted connection between the client and the Cloud SQL instance using TLS and authenticating requests through Google Cloud IAM, ensuring that only authorized users or services can access the database. The proxy runs locally or alongside applications, exposing a local TCP port or Unix socket that applications can use as if they were connecting to a standard database. This abstraction simplifies development and deployment by allowing developers to use familiar database clients while the proxy handles authentication and encryption behind the scenes. It supports both public and private IP connections and can be deployed in environments such as local machines, virtual machines, Kubernetes clusters, or as a sidecar container.

River is a durable background job system for Ruby on Rails, designed for reliability, observability, and simplicity. It provides persistent queues, native Active Job support, automatic retries, and real-time job monitoring through its admin interface. River focuses on clear diagnostics, performance, and minimal configuration, making it ideal for production-ready job handling in Rails apps.

dbtpl is a Go-based tool that brings templated SQL into your codebase in a clean and structured way. It allows developers to define raw SQL queries in .tpl.sql files and compile them into Go code with strong typing and minimal overhead. By combining SQL’s power with Go’s safety and performance, dbtpl is ideal for teams that want full SQL control without sacrificing maintainability.

noisia is a PostgreSQL workload generator designed for testing and benchmarking query performance. It simulates real-world SQL traffic by replaying or generating workloads based on defined query profiles. noisia is useful for stress testing databases, tuning configurations, and validating changes in performance-sensitive environments.

SPQR is a sharding proxy for PostgreSQL that enables horizontal scalability by distributing queries across multiple PostgreSQL instances. Designed for large-scale, multi-tenant architectures, SPQR routes, rewrites, and manages SQL queries to ensure they are executed efficiently across shards. It provides a PostgreSQL-compatible interface so applications can scale transparently without code changes.

sqler is a lightweight API gateway that automatically exposes your SQL database as a RESTful API. It allows developers to run parameterized SQL queries safely over HTTP, turning databases into microservices without writing backend code. sqler is great for prototyping, dashboards, and internal tools with quick database integration.

sqldef is a schema migration tool that automatically generates SQL migration statements by comparing database schemas. Instead of writing migrations manually, developers define the desired schema, and sqldef computes the difference. It's compatible with MySQL, PostgreSQL, SQLite, and others, making migrations safer and more maintainable.