# mysql

Lightweight open-source browser-based database GUI

Outerbase Studio is a lightweight, open-source database GUI that runs directly in your browser. It supports PostgreSQL, MySQL, and SQLite with a modern interface featuring intelligent query editor with auto-completion, multi-query execution, advanced data editing with staging and preview, and high-performance table rendering for thousands of rows. Also available as an Electron desktop client for databases requiring specialized drivers.

Database schema management for modern teams

Database schema management and migration tool by Ariga with a declarative schema-as-code approach. Features automatic migration planning, CI/CD integration, and drift detection to keep database schemas in sync across environments. Supports PostgreSQL, MySQL, MariaDB, and SQLite, making database changes as reviewable and version-controlled as application code.

Promise-based Node.js ORM

Mature, promise-based ORM for Node.js supporting PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server. Features model definitions with validations, eager/lazy loading, transactions, migrations, raw queries, and lifecycle hooks. Supports soft deletes, scopes, and virtual fields. One of the oldest and most battle-tested Node.js ORMs, widely used in enterprise apps though increasingly succeeded by Prisma and Drizzle in new projects.

MySQL-compatible serverless database

Relational database platform for MySQL and Postgres with Vitess-backed MySQL scale, PlanetScale Postgres, query insights, deploy-request workflows, and Database Traffic Control. It fits production teams that need managed relational performance, safe schema changes, replicas, and database expertise rather than a simple hobby database.

Open-source SQL editor and DB manager

Beekeeper Studio is a modern, open-source SQL editor and cross-platform database GUI for MySQL, PostgreSQL, SQLite, SQL Server, MariaDB, CockroachDB, Amazon Redshift, Oracle, and LibSQL. Focuses on a clean interface, fast multi-tab editor, saved queries, data export, and schema browsing — a lightweight alternative to DBeaver or DataGrip for everyday database work on Windows, macOS, and Linux.

JetBrains database IDE

JetBrains' professional database IDE with intelligent SQL assistance, schema navigation, data editor, and admin tools for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis, and more. Features context-aware completion, error detection, explain plan visualization, data export, and version control for schema changes. Part of JetBrains All Products pack or standalone. The premium choice for database development.

Universal database tool

DBeaver is a free, open-source universal database GUI and SQL client supporting 100+ engines including PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, Cassandra, and Redis. Offers a consistent cross-platform interface for schema browsing, visual query building, SQL execution, data editing, ER diagrams, and data migration between heterogeneous databases, all in a single Java-based desktop app.

Modern database management GUI

Native database management GUI for macOS, Windows, and Linux that provides a fast, clean interface for working with PostgreSQL, MySQL, SQLite, SQL Server, Redis, CockroachDB, and more. Features an intuitive query editor with auto-completion, visual table editor for inline data editing, import/export in multiple formats, SSH tunnel support, and connection management. Known for its speed and polished UI compared to heavier tools like DBeaver. Popular among Mac developers.

ORM for TypeScript and JavaScript

Full-featured ORM for TypeScript and JavaScript supporting Active Record and Data Mapper patterns. Works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, and MongoDB. Features decorator-based entity definitions, migrations, relations (one-to-one, many-to-many), lazy/eager loading, query builder, transactions, and caching. Supports both Node.js and browser runtimes. 34K+ GitHub stars. Mature but losing mindshare to Prisma and Drizzle for new TypeScript projects.

SQL query builder for Node.js

Flexible SQL query builder for Node.js supporting PostgreSQL, MySQL, SQLite, Oracle, and MSSQL. Chainable API for constructing queries with parameterized bindings. Features schema builder, migration system, seed files, transaction support, and connection pooling. Foundation for ORMs like Bookshelf.js and Objection.js. One of the most established query builders in the Node.js ecosystem.

Type-safe SQL query builder for TS

Type-safe SQL query builder for TypeScript that provides auto-completion and compile-time type checking without the abstraction overhead of a traditional ORM. Write queries that map directly to SQL while getting full TypeScript inference from your database schema. Supports PostgreSQL, MySQL, and SQLite with migrations, transactions, and raw SQL escape hatches. Lightweight with zero dependencies. Ideal for developers who want SQL control with TypeScript safety. Growing Knex.js alternative.