# Oracle SQL Explorer

> Use this tool when you need to query Oracle databases directly from AI interfaces without writing code, execute SQL queries, or explore database structures. It solves problems for data analysts and developers by providing a standardized interface to list tables and describe table structures. The Oracle SQL Explorer takes SQL queries as input and returns formatted results, making it ideal for use cases that require direct database access and exploration.

Canonical page: https://skillsregistry.net/skills/yyue9527-oracle-sql  
JSON: https://api.skillsregistry.net/v1/skills/yyue9527-oracle-sql

## Description

Oracle MCP Server provides a Spring Boot-based interface to Oracle databases, enabling AI assistants to execute SQL queries, list tables, and describe table structures through standardized tool calls. Developed by yue9527, it leverages Spring AI's MCP server capabilities to expose database operations as tools, with built-in security measures that prevent non-SELECT statements in production. The implementation includes comprehensive error handling and result formatting, making it particularly valuable for data analysts and developers who need to query Oracle databases directly from AI interfaces without writing code.

## Trust

- **Trust score (0–1):** 0.64
- **Verification tier:** scanned
- **Last scanned:** 2026-09-01

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-01

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/yyue9527-oracle-sql)
- **Repository:** <https://github.com/yyue9527/oracle-mcp-server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "yyue9527-oracle-sql"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/yyue9527-oracle-sql` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/yyue9527-oracle-sql/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt
