# Oracle Database

> Use this tool when you need to access and retrieve data from Oracle databases without requiring direct database credentials. It solves problems related to data exploration and retrieval by providing a secure interface to list tables, describe table structures, and execute read-only SQL queries. The tool takes database connection details and SQL queries as inputs and returns database schema information and query results as outputs.

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

## Description

A Model Context Protocol server that provides AI assistants with direct access to Oracle databases. It exposes three key tools: listing all tables, describing table structures (including columns, data types, and key relationships), and executing read-only SQL queries. The implementation uses Python's oracledb library to handle database connections asynchronously, with connection details securely managed through environment variables. This server enables AI assistants to explore database schemas and retrieve data without requiring direct database access credentials.

## Trust

- **Trust score (0–1):** 0.92
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

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

## Source

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

## 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": "hdcola-oracle"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/hdcola-oracle` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/hdcola-oracle/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