Open Source Go Database Clients

Tiny RDM is a lightweight Redis desktop manager for inspecting, editing, and administering Redis databases. Built with Go, Wails, and Vue, it offers native applications for Windows, macOS, and Linux alongside a Docker-deployable web edition. Users can manage multiple connections through SSH tunnels, SSL, Sentinel, Cluster, and proxy configurations. Its graphical editor supports strings, hashes, lists, sets, sorted sets, and streams. Incremental SCAN operations allow efficient browsing of databases containing millions of keys. Advanced tools provide data decoding, decompression, and import or export operations. An integrated command interface supports direct Redis commands, monitoring, and slow query inspection. Tiny RDM includes customizable themes and multilingual support.

dblab is a fast and lightweight interactive terminal based UI application for PostgreSQL, MySQL and SQLite3, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. dblab was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL/MySQL/SQLite3/Oracle/SQL Server databases.

Golang SQL database client for ClickHouse. There are two version of this client, v1 and v2, available as separate branches. v1 is now in a state of maintenance, we will only accept PRs for bug and security fixes. Uses ClickHouse native format for optimal performance. Utilizes low level ch-go client for encoding/decoding and compression (versions >= 2.3.0). Supports native ClickHouse TCP client-server protocol. Compatibility with database/sql (slower than native interface!). Database/sql supports http protocol for transport. (Experimental). Marshal rows into structs (ScanStruct, Select). Unmarshal struct to row (AppendStruct). Connection pool Failover and load balancing. Bulk write support (for database/sql use begin->prepare->(in loop exec)->commit). AsyncInsert, named and numeric placeholders support. LZ4/ZSTD compression support. External data.

ES-King is a lightweight desktop client for managing Elasticsearch clusters through a graphical interface. It connects through REST APIs, providing broad compatibility with Elasticsearch versions. Users can monitor cluster health, node performance, shard allocation, and resource consumption. Its index management tools support creating, modifying, deleting, and migrating indexes. A document browser enables searches, JSON editing, bulk imports, and field analysis. The integrated REST console provides multiple query tabs, saved requests, and structured result visualization. Administrative tools include snapshot management, lifecycle policies, and cluster diagnostics. Built with Wails, ES-King supports Windows, macOS, and Linux with multilingual interface options.

Kafka King is a desktop Apache Kafka management client built with Wails and franz-go. It provides graphical tools for connecting to clusters, inspecting brokers, and configuring topics. Users can create or delete topics, manage partitions, and examine consumer groups and message offsets. A message browser supports real-time consumption, filtering, and exporting records. Producer tools allow messages to be sent individually or in batches with custom headers. Schema Registry integration supports Avro, JSON, and Protobuf decoding. Advanced administration includes offset resets, partition reassignment, message purging, and cluster health checks. Secure connections support TLS, SASL, Kerberos, OAuth, AWS MSK IAM, and SSH tunneling. Kafka King runs on Windows, macOS, and Linux.

Basic types, integers, floats, string, bool, time.Time, net.IP, net.IPNet. All struct fields are nullable by default and zero values (empty string, 0, zero time, empty map or slice, nil ptr) are marshalled as SQL NULL. pg:",notnull" is used to add SQL NOT NULL constraint and pg:",use_zero" to allow Go zero values. sql.NullBool, sql.NullString, sql.NullInt64, sql.NullFloat64 and pg.NullTime. Structs, maps and arrays are marshalled as JSON by default. PostgreSQL multidimensional Arrays using array tag and Array wrapper. Hstore using hstore tag and Hstore wrapper. go-pg supports 2 last Go versions and requires support for Go modules. So make sure to initialize a Go module. ORM supports has one, belongs to, has many, and many to many with composite/multi-column primary keys. ForEach that calls a function for each row returned by the query without loading all rows into the memory.