Oracledb FAQs

Question 1

Can I limit the number of records returned by a query?

Accepted Answer

Yes, Oracledb allows you to configure the query limit size, controlling the number of records returned by a query. The default value is 10 records.

Question 2

What are the key features of Oracledb?

Accepted Answer

Key features include providing Oracle Database context to LLMs, SQL generation capabilities, prompt-based result retrieval, table/column whitelisting, and configurable query limits.

Question 3

What is Oracledb?

Accepted Answer

Oracledb is a tool that allows Large Language Models (LLMs) to interact with Oracle databases. It enables LLMs to generate SQL statements based on prompts and retrieve data from the database.

Question 4

How does Oracledb enhance security?

Accepted Answer

Oracledb provides whitelisting features for tables and columns, ensuring that LLMs only access permitted data, enhancing security and relevance.

Question 5

How do I install and configure Oracledb?

Accepted Answer

Install the package using `pip install oracledb_mcp_server`. Create a `.env` file with your Oracle DB connection string and configure table/column whitelists. Refer to the provided documentation for detailed instructions.

Oracledb

Key Features

Use Cases

Oracledb

Key Features

Use Cases