Beekeeper Studio

Visit site Alternatives

Score7.1

Rank#5 of 46

From$0.75/mo

Free planYes

Free trialYes

Runs onLinux, macOS, Windows

Summary

Beekeeper Studio is an open source SQL client and database manager for Linux, macOS, and Windows. It supports databases including MySQL, PostgreSQL, SQLite, SQL Server, Oracle, MongoDB, Snowflake, Redis, and BigQuery, though availability varies by plan. Its SQL editor includes syntax highlighting, autocomplete, saved queries, query folders, and result visualization. A spreadsheet-like view lets users browse and edit table data, including SQL query results; a no-code table editor and automatically generated ERD provide other ways to work with database structure. The desktop app connects directly to databases, and the maker says it can run offline, including in air-gapped environments. Professional and Business add cloud workspaces for syncing connections and queries and sharing them with a team. Those plans also include AI Shell, which can use a user's Claude, OpenAI, or Gemini key and asks before executing SQL. Community is free and aimed at individuals, nonprofits, and organizations below stated size thresholds. Paid plans start at 9.00 USD per year per user, billed yearly.

Who it is for

It suits people who manage or query databases from a desktop computer. Community is intended for individuals, nonprofits, and organizations under the stated size thresholds; teams can consider paid plans with cloud workspaces.

What is good

Runs on Linux, macOS, and Windows
SQL editor includes autocomplete and saved queries
Spreadsheet-like editing includes query results
Offline use is supported, including air-gapped systems
Exports to CSV, Excel, JSON, and other formats

What to know first

Database availability varies by plan
Cloud workspaces require Professional or Business
Community edition has stated organization eligibility limits

Verdict

Beekeeper Studio brings SQL editing, table changes, and schema exploration into a desktop client. Check database availability and plan eligibility before choosing an edition.

Beekeeper Studio plans and pricing

All plans

Community Free Common databases · Unlimited connections · No tab limits · Intended for individuals, non-profits, and organizations under stated size thresholds beekeeperstudio.io · 30 Sept 2026

Indie $9/yr per user, billed yearly One device · 2 users per license · Lifetime access license beekeeperstudio.io · 30 Sept 2026

Professional $14/yr per user, billed yearly Unlimited devices · 20 users per license · Email support · Lifetime access license beekeeperstudio.io · 30 Sept 2026

Indie $18/mo per user One device · 2 users per license · Lifetime access license beekeeperstudio.io · 30 Sept 2026

Business $18/yr per user, billed yearly Unlimited devices and users · Invoice payment · Priority support · Air-gapped system support beekeeperstudio.io · 30 Sept 2026

Professional $28/mo per user Unlimited devices · 20 users per license · Email support · Lifetime access license beekeeperstudio.io · 30 Sept 2026

Compared on database client software

Free plan: Yesbeekeeperstudio.io
Paid from: $9/user/mobeekeeperstudio.io
Deployment: desktopbeekeeperstudio.io
Database support: PostgreSQL, MySQL, SQLite, SQL Server, Amazon Redshift, CockroachDB, MariaDB, TiDB, Google BigQuery, Redis, GreengageDB, Oracle Database, Cassandra, ScyllaDB, Firebird, LibSQL, ClickHouse, DuckDB, SQL Anywhere, MongoDB, Trino, Presto, SurrealDB, DynamoDB, Snowflakebeekeeperstudio.io
SSH tunneling: Yesbeekeeperstudio.io
Data editing: Yesbeekeeperstudio.io
Visual query builder: Yesbeekeeperstudio.io
Result export formats: CSV, Excel, JSON, Markdown, TSV, SQL, JSONLbeekeeperstudio.io
Query history: Yesbeekeeperstudio.io

Facts

Product: Beekeeper Studio is an open source SQL client and database manager for working with databases including MySQL, Postgres, SQLite, and SQL Server.beekeeperstudio.io · 30 Sept 2026
SQL editor: Its SQL editor offers syntax highlighting, autocomplete, saved queries, query folders, and query result visualization.beekeeperstudio.io · 30 Sept 2026
Schema tools: The product includes a no-code table editor and an interactive, automatically generated ERD for exploring database structure.beekeeperstudio.io · 30 Sept 2026
Connections: The features page lists SSL connections and SSH tunnels, while the Business plan comparison includes Kerberos, Windows authentication, Amazon IAM, and Azure EntraID database connections.beekeeperstudio.io · 30 Sept 2026
AI Shell: The AI Shell is included with Professional and Business plans; the download page says it supports users’ own Claude, OpenAI, or Gemini key and asks before running SQL.beekeeperstudio.io · 30 Sept 2026
Cloud workspaces: Professional and Business plans include cloud workspaces for syncing connections and queries across devices and sharing them with a team.beekeeperstudio.io · 30 Sept 2026
Security: The desktop application connects directly from the computer to the database, and the maker says none of the user’s data leaves the machine unless optional cloud services are used.beekeeperstudio.io · 30 Sept 2026
Privacy and offline use: The maker says the app can run entirely offline for air-gapped systems and contains no user or behavior tracking.beekeeperstudio.io · 30 Sept 2026
Support: Professional includes email support, and Business includes prioritized features and support; security questionnaires can be requested from sales.beekeeperstudio.io · 30 Sept 2026
Free edition eligibility: The pricing FAQ says Community Edition is intended for students, individuals, non-profits, and small businesses with fewer than 10 employees and/or annual revenue below $1 million.beekeeperstudio.io · 30 Sept 2026
Company: Beekeeper Studio says it is built and maintained by Matthew Rathbone in Dallas, Texas, and that development started in 2019.beekeeperstudio.io · 30 Sept 2026