oracledb Plugin
Plugin Claude Code Database Databases & StorageThe explanation below is AI-generated. Please verify it against the sources.
oracledb is a plugin (agent skills package) that lets AI coding agents such as Gemini CLI, Claude Code, Codex, and Antigravity connect to and interact with Oracle Database instances using natural language. According to the README, it enables querying data, exploring schema metadata, monitoring active sessions and resource usage, analyzing query execution plans, and checking object health (e.g., invalid objects). It is currently in beta (pre-v1.0) and may see breaking changes before the first stable release. Setup requires Oracle Database access credentials (connection string, username, password, optional wallet path) and Oracle privileges such as CREATE SESSION and SELECT on V$ and DBA_ views.
Overview
According to the repository, oracledb is a set of agent skills (installed as a plugin) that integrates into AI agent environments to let users manage Oracle Database instances, run queries, explore schemas, and troubleshoot issues through natural language prompts, rather than a hosted SaaS product itself.
What you can do with oracledb
- Query data with natural language, e.g. "Show me the first 10 rows from the EMPLOYEES table" or "What is the total salary by department?" (README, Usage Examples)
- Monitor active sessions and resource consumption, e.g. "List all active sessions" (README)
- Analyze query performance, e.g. "Explain the execution plan for this query: SELECT * FROM orders WHERE order_id = 100" (README)
- Check storage usage, e.g. "What is the tablespace usage?" (README)
- Check object health, e.g. "List all invalid objects in the schema" (README)
- Install the skills into Gemini CLI, Antigravity, Claude Code, or Codex, or via the npx skills tool (README, Installation & Usage)
Sources
Original description (English)
Connect, query, and interact with Oracle Databases and their data.
History of oracledb
- Plugin Added oracledb