Database Management
API Development
Data Science & ML
Oracledb icon

Oracledb

Createdrahgadda

Enables Large Language Models to interact with Oracle Databases, generate SQL statements, and return results using prompts.

Github Repo

About

Oracledb allows LLMs to interact with Oracle databases by providing configured table and column context. It installs a Model Context Protocol (MCP) server, enabling LLMs to generate SQL statements and retrieve results based on user prompts. The server uses environment variables for configuration, including database connection strings and whitelists for tables and columns.

Key Features

  • Configurable query limit size
  • Provides configured Oracle Database table/column context to LLMs
  • Enables LLMs to generate SQL statements
  • 1 GitHub stars
  • Supports whitelisting tables and columns for security and relevance
  • Allows LLMs to return results from Oracle Database using prompts

Use Cases

  • Generating SQL queries from natural language prompts
  • Building applications that leverage LLMs to interact with Oracle databases
  • Integrating LLMs with Oracle databases for data retrieval