database
Connect AI clients to MySQL, PostgreSQL, SQLite and MariaDB via stdio.
View on GitHub Updated 2026-06-16
What is the database MCP server?
This MCP server acts as a bridge between language models and popular SQL databases. It is designed for local execution using the stdio transport, allowing secure, direct access without exposing network ports.
Users configure database credentials through environment variables or command-line arguments before launching the server process. Once running, the server can execute queries and return results to the connected AI client.
Install & connect
Add this to your MCP client config. Pick your client below and copy.
{
"mcpServers": {
"database": {
"command": "npx",
"args": [
"-y",
"ghcr.io/haymon-ai/database:0.5.0"
]
}
}
}Package: ghcr.io/haymon-ai/database:0.5.0 (oci)
Example prompts
Once connected, try asking your AI client:
“List all tables in the connected PostgreSQL database
“Show the schema and first five rows of the users table
“Run a query to count orders placed in the last 30 days
“Explain the foreign key relationships between customers and orders tables
Security & permissions
Runs locally via stdio and requires database credentials (host, port, username, password) passed as environment variables or arguments. It only accesses databases for which valid credentials are supplied.
What you can do with database
Query local development databases
Run ad-hoc SELECT, INSERT, and UPDATE statements against a local SQLite or PostgreSQL instance during application development.
Generate reports from production data
Ask natural-language questions that translate into complex joins and aggregations across MySQL or MariaDB tables.
Explore schema and data relationships
Inspect table structures, foreign keys, and sample rows to understand an unfamiliar database schema.
How to use database
- 1Install the database MCP server package via npm or pip.
- 2Set required environment variables for the target database (DB_TYPE, DB_HOST, DB_USER, DB_PASSWORD, etc.).
- 3Add the server to your MCP client configuration using stdio transport.
- 4Restart the AI client so it can discover and start the database server process.
- 5Begin querying by typing natural-language requests in the client interface.
database: pros & cons
Pros
- +Supports four major relational database engines in one package
- +Simple stdio transport requires no network configuration
- +Lightweight and runs entirely on the local machine
- +Enables natural-language database interaction without writing SQL
Cons
- –No tools are documented in the provided README, limiting discoverability
- –Requires manual credential management through environment variables
- –Limited to read/write operations supported by the underlying database driver
Did you find this helpful?
Frequently asked questions
MySQL, MariaDB, PostgreSQL, and SQLite are supported.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar MCP servers
Other databases & data connectors worth a look.
