AI Shell
The Beekeeper Studio AI Shell is modelled after Claude Code and Aider. It is designed to increase the productivity of technical users (like you!).
Deep Coding and AI Self Learning
The AI Shell embeds your agent right inside Beekeeper Studio. It has deep SQL awareness and the ability to explore schemas, understand relations and constraints, and write and execute SQL (with permission), right inside the app.
See our website for videos, screenshots, and more.
How to use the AI Shell
- Choose your AI provider of choice (in beta only Anthropic is available)
- Enter your API key
- Ask questions
- The AI explores your data
- Get results
- Ask more questions
AI Shell Pricing
The AI Shell is included in all paid versions of Beekeeper Studio, with no additional charge. Note that you are responsible for the costs incurred with your AI provider, as Beekeeper does not act as a middle-man in any way.
All downloads of Beekeeper Studio come with a 14 day free trial, download Beekeeper Studio to try the AI Shell right now.
AI Shell Tools
Your AI agent has access to the following tools from within Beekeeper Studio:
- Listing schemas, tables, views, functions, and procedures
- Viewing table relations and constraints
- Looking at your saved queries for guidance
- Checking your open tabs for guidance
- Writing and executing SQL (with permission)
AI Shell Configuration
You can configure the AI Shell using the Beekeeper Studio configuration system.
AI Shell Data Privacy
The AI shell is 100% optional. Even when in-use, no data is ever sent from the AI Shell to the Beekeeper Studio servers. The AI Shell communicates directly with your AI Agent of choice -- no middlemen.
To start using the AI Shell you must choose your agent and enter an API key. By doing so, you are permitting the Beekeeper Studio AI shell to communicate with your chosen AI agent.
Information Shared With The Agent
The AI Shell allows your agent to explore your data's schema, run SQL, and read results. The AI Shell will show you what the AI sees as it is working, nothing is hidden from view.
The AI shell will send the following information to your agent when you use the shell:
- Table names and column names
- Table structure, like relations and indexes
- Previously executed SQL queries
- The results of SQL queries approved for execution (by you) within the AI Shell
- Any query execution errors that occur
AI Shell asks permission to run SQL
The AI Shell can run SQL queries, then view the results of those queries. This is a key part of how the shell navigates around your database to figure things out.
There are some limited actions the AI shell can take without your permission, but it will always ask for your explicit consent when running SQL. This gives you the chance to review the code and reject it whenever you have concerns.
Disabling the AI Shell
You can disable the AI shell entirely by adding a flag to either your personal or administrator configuration file to disable the shell.
Even if the application user has previously entered an API key, this setting will disable the feature and lock out any further usage.