Open-source Go projects categorized as MySQL

Top 23 Go MySQL Projects

  • tidb

    TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial

    Project mention: Ask HN: Who is hiring? (January 2023) | news.ycombinator.com | 2023-01-02

    PingCAP | https://www.pingcap.com | Database Engineer, Product Manager, Developer Advocate and more | Remote in California | Full-time

    We work on a MySQL compatible distributed database called TiDB https://github.com/pingcap/tidb/ and key-value store called TiKV.

    TiDB is written in Go and TiKV is written in Rust.

    More roles and locations are available on https://www.pingcap.com/careers/

  • vitess

    Vitess is a database clustering system for horizontal scaling of MySQL.

    Project mention: Database on a limited budget: Pay per-usage database or "cheap" config of Cloud SQL? | reddit.com/r/googlecloud | 2023-01-08

    There are a few products that claim to "solve" these issues with MySQL/Postgres, but one look at the excellent Kyle Kingsbury's work showcases just how brittle these systems are, even when they aren't distributed. Just about the only distributed MySQL based provider I trust is Planetscale, because their underlying software Vitess, was invented at Google for use at YouTube. However, even we don't use it anymore, as we've long since moved everything into Spanner.

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

  • dolt

    Dolt – Git for Data

    Project mention: storage of pictures into a database, and referencing them. | reddit.com/r/Database | 2023-01-30

    The database is Dolt (https://github.com/dolthub/dolt) but it would work the same way in MySQL.

  • go-sql-driver/mysql

    Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)

    Project mention: Make Deno MySQL driver works better | dev.to | 2022-12-01

    Authentication method mismatch is not allowed to occur more than once. It is not a part of MySQL protocol. go-sql-driver also has the same rule.

  • gh-ost

    GitHub's Online Schema-migration Tool for MySQL

    Project mention: Changing column from longtext to mediumtext taking over 2 hours | reddit.com/r/mysql | 2022-11-04

    Not sure which version of MySQL you're using, but one approach would be to use a tool like pt-online-schema-change (from Percona) or g-host -- which will create a duplicate table and then swap it in place of the original table. It's a safer approach when operating in production environments. Here's a good comparison of the tools many people use https://planetscale.com/docs/learn/online-schema-change-tools-comparison

  • migrate

    Database migrations. CLI and Golang library.

    Project mention: Managing external database versions in Kubernetes | reddit.com/r/kubernetes | 2022-12-25

    We use golang-migrate for our platforms and it’s works exceptionally well even when many pods are active. https://github.com/golang-migrate/migrate

  • usql

    Universal command-line interface for SQL databases

    Project mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • sqlc

    Generate type-safe code from SQL

    Project mention: You might not need an ORM | news.ycombinator.com | 2023-01-25
  • go-clean-arch

    Go (Golang) Clean Architecture based on Reading Uncle Bob's Clean Architecture

    Project mention: A Go (Golang) Backend Clean Architecture Project | reddit.com/r/golang | 2023-01-08

    Try this

  • kingshard

    A high-performance MySQL proxy

  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

    Project mention: ORM or no ORM (and which ones)? | reddit.com/r/golang | 2023-01-17

    SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.

  • bytebase

    Database CI/CD for DevOps teams. https://www.bytebase.com

    Project mention: Ask HN: How do you test SQL? | news.ycombinator.com | 2023-01-31

    We built a GUI based solution called https://github.com/bytebase/bytebase. You may also take a look.

  • orchestrator

    MySQL replication topology management and HA

  • octosql

    OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

    Project mention: Show HN: ClickHouse-local – a small tool for serverless data analytics | news.ycombinator.com | 2023-01-05

    Congrats on the Show HN!

    It's great to see more tools in this area (querying data from various sources in-place) and the Lambda use case is a really cool idea!

    I've recently done a bunch of benchmarking, including ClickHouse Local and the usage was straightforward, with everything working as it's supposed to.

    Just to comment on the performance area though, one area I think ClickHouse could still possibly improve on - vs OctoSQL[0] at least - is that it seems like the JSON datasource is slower, especially if only a small part of the JSON objects is used. If only a single field of many is used, OctoSQL lazily parses only that field, and skips the others, which yields non-trivial performance gains on big JSON files with small queries.

    Basically, for a query like `SELECT COUNT(*), AVG(overall) FROM books.json` with the Amazon Review Dataset, OctoSQL is twice as fast (3s vs 6s). That's a minor thing though (OctoSQL will slow down for more complicated queries, while for ClickHouse decoding the input is and remains the bottleneck).

    [0]: https://github.com/cube2222/octosql

  • space-cloud

    Open source Firebase + Heroku to develop, scale and secure serverless apps on Kubernetes

    Project mention: Show HN: Algorithmic Trading for Everyone | news.ycombinator.com | 2022-04-21
  • goose

    A database migration tool. Supports SQL migrations and Go functions.

    Project mention: DB schema management strategy (migrations) | reddit.com/r/golang | 2022-10-25

    Try: github.com/pressly/goose

  • xo

    Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

    Project mention: Help with XO's new templating, how to access fields and params | reddit.com/r/golang | 2022-08-23

    I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.

  • upper.io/db

    Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.

    Project mention: [Hiring] Remote Golang job: Senior Backend Engineer (Go) at Horizon (Toronto, Canada) | reddit.com/r/jobbit | 2022-05-28

    You will be joining the expert Go team at Horizon, previously who in our spare time + for fun, authored OSS projects like chi (https://github.com/go-chi/chi), upper/db (https://github.com/upper/db), webrpc (https://github.com/webrpc/webrpc), goware (https://github.com/goware), and much more. Our Go codebases are extremely clean and the patterns we've built have been shaped over 7 years of writing production Go systems and open source projects. These are the patterns which we apply to our infrastructure at Horizon in our products Skyweaver and Sequence.

  • dbmate

    :rocket: A lightweight, framework-agnostic database migration tool.

    Project mention: New post: Is Prisma better than your 'traditional' ORM? | reddit.com/r/node | 2022-12-06

    Would always go for a language agnostic migration tool, e.g. https://github.com/amacneil/dbmate to stay flexible and stay away from lock-in effects (besides sql).

  • graphjin

    GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks

    Project mention: Advice on ORMs with REST/GraphQL & Hasura/PostGraphile implementation | reddit.com/r/graphql | 2023-02-01

    Checkout GraphJin it's an automatic GraphQL to SQL compiler, you write your database queries in GraphQL instead of SQL and it compiles them into efficient SQL on the fly. Works as a library in GO and NodeJS. https://github.com/dosco/graphjin

  • algernon

    :tophat: Small self-contained pure-Go web server with Lua, Markdown, HTTP/2, QUIC, Redis and PostgreSQL support

  • gormt

    database to golang struct

  • sqler

    write APIs using direct SQL queries with no hassle, let's rethink about SQL

    Project mention: sqler: Write APIs using direct SQL queries with no hassle, let's rethink about SQL | reddit.com/r/himigifavievcu | 2022-07-29
  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-02-01.

Go MySQL related posts


What are some of the best open-source MySQL projects in Go? This list will help you:

Project Stars
1 tidb 33,288
2 vitess 15,431
3 dolt 13,999
4 go-sql-driver/mysql 13,021
5 gh-ost 10,785
6 migrate 10,705
7 usql 7,815
8 sqlc 7,329
9 go-clean-arch 7,198
10 kingshard 6,138
11 SQLBoiler 5,551
12 bytebase 4,827
13 orchestrator 4,775
14 octosql 4,328
15 space-cloud 3,718
16 goose 3,405
17 xo 3,309
18 upper.io/db 3,244
19 dbmate 3,049
20 graphjin 2,585
21 algernon 2,176
22 gormt 2,108
23 sqler 2,021
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives