Database FAQs

Question 1

How do I configure a new database connection?

Accepted Answer

Simply start the web UI (`npm run dev`), navigate to the configuration section, enter your database connection details (such as host, user, password, database type, and SSL mode), and save the new configuration. You can then select it for use.

Question 2

Does the tool truly enforce read-only access?

Accepted Answer

Yes, the tool is designed for strict read-only access. It uses database session characteristics to prevent write operations and actively rejects all non-SELECT SQL queries, ensuring your data remains unmodified.

Question 3

Which database types are supported by this tool?

Accepted Answer

This tool supports connections to PostgreSQL, MySQL, and MariaDB databases. It also includes options for configuring SSL to ensure secure database communication.

Question 4

What is the primary function of the Database tool?

Accepted Answer

The Database tool exposes a read-only database server via Model Context Protocol (MCP) and provides a user-friendly web UI for managing database configurations, viewing usage history, and interacting with your data.

Question 5

How can an agent or model interact with the MCP server?

Accepted Answer

Your agent or model can connect to the MCP server (started with `npm run mcp`) via standard I/O. It can then utilize exposed tools like `list_tables`, `preview_table`, and `run_select` by referencing your saved database configuration name.

Database

Database

Key Features

Use Cases

Key Features

Use Cases