Skip to content

gemini-cli-extensions/oracledb

claude-code

Skills for Oracle DB

OracleDB is an open-source set of agent skills from Google that let AI coding agents query, monitor and manage Oracle Database instances in natural language. Packaged as a Gemini CLI extension, it also installs into Claude Code, Codex and Antigravity.

9 stars4 forksJavaScriptUpdated July 2026
✅ Reviewed by My AI Guide, vetted for vibe builders and developers

Our Review

Built by Google and released under the Apache-2.0 license, the OracleDB agent skills are part of the official gemini-cli-extensions collection. The standout detail is reach: one Apache-2.0 package installs across four AI agents (Gemini CLI, Claude Code, Codex and Antigravity) instead of locking you into a single tool.

What OracleDB adds to your agent:

  • Natural-language SQL ask your agent to "show the first 10 rows from EMPLOYEES" or "total salary by department" and it generates and runs the query against your Oracle instance.
  • Schema exploration browse tables, columns and metadata by describing what you are looking for, no DDL memorisation required.
  • Query performance analysis ask the agent to explain an execution plan for a slow statement and surface where time is spent.
  • Session and resource monitoring list active sessions, check tablespace usage and watch resource consumption through plain-English prompts.
  • Object health checks find invalid objects in a schema and diagnose common database issues without leaving the agent.
  • Code generation generate data classes and snippets from your existing table schemas to speed up application development.

Compatibility:

  • Claude Code v2.1.94+ install with /plugin marketplace add then /plugin install oracledb@oracledb-marketplace.
  • Gemini CLI v0.6.0+, Codex v0.117.0+, Antigravity v1.14.2+ clone the repo or use the open npx skills add command, then set your ORACLE_CONNECTION_STRING, username and password.
  • Oracle permissions needs CREATE SESSION for connectivity plus SELECT on V$ and DBA_ views for the monitoring and diagnostics features.

Limitations:

The project is in beta (pre-v1.0) and the maintainers warn of possible breaking changes before the first stable release, so pin a version tag in production. It connects through Oracle's Toolbox binary over MCP, so failed downloads or connection-string errors are the most common setup problems. It only targets Oracle Database, and you still need a reachable Oracle instance with the right privileges before any skill works.

Our Verdict

OracleDB agent skills are the most direct way to drive an Oracle database from an AI coding agent in 2026, and the fact that Google ships it as Apache-2.0 across four agents makes it a low-risk thing to try.

For Vibe Builders, this removes the SQL learning curve from working with an Oracle database. You describe the data you want in plain English and the agent writes and runs the query, so you can ship features against a real enterprise database without becoming a DBA first.

For Developers and DBAs, the value is the diagnostics: execution-plan explanations, active-session lists, tablespace checks and invalid-object hunts all from inside the agent you already code in. The schema-to-code generation is a genuine time-saver on new application work.

Skip it if you do not run Oracle Database, if you need a polished GUI rather than a CLI agent workflow, or if your team cannot accept beta software in production yet. For a managed multi-database experience you may prefer a vendor-hosted tool, and for non-Oracle stacks you will need a different skill or MCP server entirely.

Frequently Asked Questions

What is OracleDB and what does it do?

OracleDB is an open-source set of agent skills from Google that connect AI coding agents to Oracle Database instances. Released under the Apache-2.0 license, it lets you run SQL queries, explore schemas, analyze query performance, monitor active sessions and check object health using natural-language prompts instead of typing raw SQL or sqlplus commands.

Is OracleDB free and open-source?

Yes. OracleDB is fully open-source under the Apache-2.0 license and free to install from the gemini-cli-extensions GitHub repository. There is no paid tier for the skills themselves, though you still need access to an Oracle Database instance, which Oracle licenses separately depending on the edition and deployment you choose.

Which AI agents support OracleDB skills?

OracleDB works with four agents as of 2026: Claude Code (v2.1.94 or higher), Gemini CLI (v0.6.0 or higher), Codex (v0.117.0 or higher) and Antigravity (v1.14.2 or higher). It is packaged as a Gemini CLI extension but installs into Claude Code as a plugin and into Codex or Antigravity by copying the skill folders, so most major agentic coding tools are covered.

Is OracleDB ready for production use?

OracleDB is currently in beta, before its v1.0 stable release, and Google warns that breaking changes are possible until then. For production it is safest to pin a specific version tag (such as 0.2.1) and grant the agent a read-only role wherever you can, since the skills can run real SQL against your live Oracle Database. Treat it as a powerful but evolving tool for now.

What do I need to get started with OracleDB?

You need one supported agent installed, a reachable Oracle Database instance, and the connection details set as environment variables: ORACLE_CONNECTION_STRING, ORACLE_USERNAME and ORACLE_PASSWORD. Your database user needs CREATE SESSION for basic connectivity plus SELECT privileges on the V$ and DBA_ views to use the monitoring and diagnostics skills.

What is oracledb?

OracleDB is an open-source set of agent skills from Google that let AI coding agents query, monitor and manage Oracle Database instances in natural language. Packaged as a Gemini CLI extension, it also installs into Claude Code, Codex and Antigravity.

How do I install oracledb?

Visit the GitHub repository at https://github.com/gemini-cli-extensions/oracledb for installation instructions.

What license does oracledb use?

oracledb uses the Apache-2.0 license.

What are alternatives to oracledb?

Explore related tools and alternatives on My AI Guide.

🔒

Open source: source code publicly visible

Anyone can inspect exactly what this repo does on GitHub before using it. Apache-2.0 licensed.

Reviewed by My AI Guide for relevance, quality, and active maintenance before listing.

Install in Claude Code:

/install oracledb

Related Tools

View all