Beekeeper Studio
beekeeperstudio.io
- Free plan
- Open source
- Windows
- macOS
- Linux
- Browser extension
- API
What Beekeeper Studio is
Beekeeper Studio is an open source desktop SQL client and database manager for Linux, macOS and Windows. It works with databases such as PostgreSQL, MySQL, SQLite and SQL Server, while availability of other databases—including Oracle, MongoDB, Snowflake, Redis and BigQuery—varies by plan. Its SQL editor provides syntax highlighting, autocomplete, saved queries, query folders and result visualization. A spreadsheet-like interface lets users browse and edit table data, including query results; a no-code table editor and automatically generated ERD offer other ways to explore database structure. The desktop app connects directly to databases. The maker says it can also run offline, including in air-gapped environments, and that user data stays on the computer unless optional cloud services are used. Professional and Business plans 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 running SQL. The free Community edition is intended for individuals, nonprofits and organizations below stated size thresholds. Paid plans start at $9 per user per month when billed annually.
Who it suits
It suits developers and database users who want a desktop SQL editor, table editing and schema exploration. Community is intended for individuals, nonprofits and organizations with fewer than 10 employees and/or annual revenue below $1 million.
Good to know, and what to watch
- Runs on Linux, macOS and Windows.
- Edits table data and query results.
- Can run offline, including in air-gapped systems.
- Community edition is free.
- Database availability varies by plan.
- Cloud workspaces require Professional or Business.
- AI Shell requires Professional or Business.
Plans
Every plan and priceCommunity
Indie
Professional
Business
Free plan · 14-day trial
Getting started
- Visit https://www.beekeeperstudio.io/.
- Choose the desktop download for Linux, macOS, or Windows.
- Select Community or a paid plan that fits your needs.
- Connect to a supported database; use SSH tunneling if needed.
- For AI Shell, use Professional or Business and provide your own Claude, OpenAI, or Gemini key.
Limits to check
The free Community edition is intended for students, individuals, nonprofits, and organizations with fewer than 10 employees and/or annual revenue below $1 million. Database availability varies by plan; cloud workspaces and AI Shell are included with Professional and Business.
The Club's review
Beekeeper Studio is a desktop SQL client for writing queries, editing data and exploring database structure. It suits individuals and teams who want those tools in a local application, with optional cloud collaboration on higher plans. Its appeal is the breadth of the workflow; database support and Community eligibility vary enough to check before choosing a tier.
Overview
The open-source client brings SQL editing, spreadsheet-style table changes and schema exploration together. It supports databases including PostgreSQL, MySQL, SQLite and SQL Server, as well as Oracle, MongoDB, Snowflake, Redis and BigQuery, with availability depending on plan. That makes it a practical candidate for mixed database environments, but users should confirm their specific database is included in the tier they need.
Connections run directly from the desktop to the database. The maker says data stays on the computer unless optional cloud services are used, and the app can run offline, including in air-gapped systems, without user or behavior tracking. This local-first approach is a clear advantage for privacy-conscious work; teams needing synced connections and queries must move to Professional or Business.
Key features
Querying and editing
The editor provides syntax highlighting, autocomplete, saved queries, query folders, history and result visualization. A visual query builder offers another route to composing queries. Together, these features support both repeatable SQL work and visual exploration, though the tier-dependent database catalog remains an important qualification.
Users can browse and change table data through a spreadsheet-like interface, including editing SQL query results directly. That can make small data corrections more convenient than switching tools, while the no-code table editor provides a visual way to work with tables.
Schema, connections and AI
An automatically generated interactive ERD helps users explore database structure. SSL connections and SSH tunnels are included among the connection features; the Business comparison also names Kerberos, Windows authentication, Amazon IAM and Azure EntraID connections. These options make the product relevant to varied connection setups, with the named enterprise authentication choices tied to Business.
Professional and Business include AI Shell, which can use a user's own Claude, OpenAI or Gemini key and asks before running SQL. That confirmation step leaves execution under user control, but the feature is limited to the higher paid tiers. Those plans also add cloud workspaces for syncing connections and queries across devices and sharing with a team.
Pricing
Beekeeper Studio is freemium. Community costs nothing and offers common databases, unlimited connections and no tab limits. It is intended for students, individuals, non-profits, and small businesses with fewer than 10 employees and/or annual revenue below $1 million. That is a generous starting point for eligible users, but the eligibility threshold rules it out for some larger organizations.
Indie costs $18 a month, billed per user, and includes one device, two users per license and lifetime access. It suits a small setup that needs a paid license without a large device footprint, but the one-device limit is a meaningful constraint. Professional costs $28 a month, billed per user, and raises the allowance to unlimited devices and 20 users per license, with email support and lifetime access. It is the more practical tier for multi-device work and adds cloud workspaces and AI Shell.
Business costs $35 a month, billed per user, with unlimited devices and users, invoice payment, priority support and air-gapped system support. It is the clearest fit for larger teams or organizations with isolated systems; the price is higher, but the user cap is removed and the plan adds business-focused support. Enterprise costs $4,999 a month, billed Contact sales, and offers an enterprise plan with custom MSA, security questionnaires and NET payment terms available for discussion.
The pricing note also states paid plans from $9/user/mo (annual) and a 14-day trial. Professional includes email support, while Business includes prioritized features and support. The distinct plan prices and per-user terms matter when comparing the headline starting price against the tier needed for particular capabilities.
Platforms
Beekeeper Studio is a desktop application for Linux, macOS and Windows. Its direct connections and offline capability suit users who prefer a local database client over a browser-based workspace.
Who it's for
Choose it if you want SQL editing, direct data changes and schema exploration in one desktop workflow, particularly when local operation or offline use matters. Community is a strong fit for eligible individuals and smaller organizations. Teams that need shared cloud workspaces, AI Shell, or Business authentication options should assess the paid tiers; it is less suitable if the required database is unavailable on the selected plan or Community eligibility does not fit.
Pros and cons
- Pros: Query editing, spreadsheet-style data updates and interactive schema exploration sit in one application, reducing the need to switch between separate database tools.
- Pros: Direct connections, offline operation and no behavior tracking support privacy-sensitive or air-gapped workflows.
- Pros: Community has unlimited connections and no tab limits for users within its stated eligibility group.
- Cons: Database availability varies by plan, so broad database support does not ensure access to every listed system on a lower tier.
- Cons: Indie is limited to one device, and Community is restricted by organization size and revenue criteria.
- Cons: Cloud workspaces and AI Shell require Professional or Business, making those team and AI features unavailable on the entry tiers.
Alternatives
For other SQL and database-client options, browse SQL Query Tools and Database Client Software.
- DBeaver is worth considering if its free, open-source Community plan or broader platform availability better fits your setup.
- dbForge Studio for PostgreSQL may suit PostgreSQL users seeking context-aware completion, query history and visual data editing in its Express plan.
- DataGrip is an alternative for individual non-commercial development, with a free Non-Commercial plan that includes AI Free.
- DbVisualizer offers a free standard feature set for commercial and non-commercial use, or a Pro option priced at $199 a year.
- Hex is a web-based alternative with a free Community plan and a Professional plan priced at $36 a month.
- MotherDuck is a web-based option with a free Lite tier capped at three internal active users and 10 GB of free storage.
- Outerbase Studio is a free, open-source database GUI that does not require a paid service for Studio.
- TablePlus may be preferable for a one-time purchase: its Team plan is $79, paid once, starts at three seats and does not auto-renew.
Verdict
Beekeeper Studio is a good choice for individuals and teams that want a local desktop client combining SQL work, data editing and schema exploration, especially when offline use matters. Its strongest reason to choose is that range in one privacy-conscious workflow; its main reason to look elsewhere is that database support and collaboration features depend on plan, while the free edition has defined eligibility limits.
The verdict
Beekeeper Studio covers SQL editing, data changes and schema exploration in a desktop app. Its free Community edition is aimed at smaller organizations and individuals; cloud workspaces and AI Shell are reserved for higher plans.
Questions people ask
Is Beekeeper Studio free?
Yes. Community costs nothing, and paid plans start at $9 per user per month when billed annually.
Which operating systems does it support?
It is a desktop application for Linux, macOS, and Windows.
Which databases can it connect to?
Listed databases include PostgreSQL, MySQL, SQLite, SQL Server, Oracle, MongoDB, Snowflake, Redis, and BigQuery. Availability varies by plan.
Is Beekeeper Studio open source?
Yes, it is an open source SQL client and database manager.
What do Professional and Business add?
Both include cloud workspaces for syncing and sharing connections and queries, plus AI Shell. Professional includes email support; Business includes priority support.
Who makes Beekeeper Studio?
Beekeeper Studio says it is built and maintained by Matthew Rathbone in Dallas, Texas, with development starting in 2019.
What the maker publishes
- 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. source
- AI Shell
- The paid AI Shell can inspect a schema, write and run SQL with permission, and verify its work using real data. source
- Cloud workspaces
- Professional and Business plans include cloud workspaces for syncing connections and queries across devices and sharing them with a team. source
- Cloud workspaces
- Cloud Workspaces synchronize connections and queries between devices and let teams share items through personal and team folders. source
- Company
- Beekeeper Studio says it is built and maintained by Matthew Rathbone in Dallas, Texas, and that development started in 2019. source
- Company legal name
- The privacy policy identifies the operating entity as Beekeeper Studio, Inc. source
- 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. source
- Connection security
- The application supports SSL-encrypted connections and SSH tunnels. source
- Database integrations
- The product lists support for MongoDB, MySQL, PostgreSQL, SQLite, SQL Server, Cassandra, ClickHouse, CockroachDB, DuckDB, DynamoDB, Firebird, BigQuery, MariaDB, Oracle, Redis, Redshift, ScyllaDB, Snowflake, StarRocks, SurrealDB, TiDB, Trino, and others. source
- Database support
- The site lists support for databases including PostgreSQL, MySQL, SQLite, SQL Server, Oracle, MongoDB, Snowflake, Redis, and BigQuery, with availability varying by plan. source
- Data browser
- The spreadsheet-style browser supports paging, inline type-aware editing, staged changes, filters, foreign-key navigation, and export of full or filtered data. source
- Data editing
- Users can browse and edit table data in a spreadsheet-like interface, including directly editing SQL query results. source
- Documentation depth
- The documentation site contains getting-started material, connection guides, SQL editor guides, security, configuration, cloud workspaces, plugins, and database-specific support tables. source
- Download formats
- Linux downloads include x86_64 and ARM64 AppImage, DEB, RPM, Snap, and other formats; AppImage requires libfuse. source
- ERD diagrams
- The Visual Schema Explorer generates interactive entity-relationship diagrams from database metadata and can export diagrams as PNG or copy them to the clipboard. source
- Founded
- 2019 source
- Founded
- The maker says the first repository commit was in 2019 and the product soft-launched in 2020. source
- 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. source
- Funding model
- The maker says it has no investors, was funded by sweat equity until paid plans launched in 2022, and is now stable and profitable. source
- Independent feature score
- FAUN.dev gave Beekeeper Studio a 73/100 score, with ease of use and pricing transparency strongest and safety features weakest. source
- Independent review summary
- Accurate Reviews describes the product as a lightweight, straightforward multi-database client suited to freelancers and small teams. source
- JSON Sidebar
- The JSON Sidebar displays rows as structured JSON and nests related foreign-key data. source
- Limit: connection documentation
- An AlternativeTo reviewer reported being unable to connect to Microsoft SQL Server and said the documentation did not help. source
- Limit: local file workflow
- A Reddit reviewer said the Community Edition lacked the ability to work directly with SQL script folders managed in Git, forcing a return to Azure Data Studio. source
Checked against the maker's pages on 14 Oct 2026.