mcp-server-database
Provides tools for executing SQL queries, listing tables, describing table schemas, listing databases, executing migrations, and retrieving full schema DDL on MySQL databases.
Provides tools for executing SQL queries, listing tables, describing table schemas, listing databases, executing migrations, and retrieving full schema DDL on PostgreSQL databases.
Provides tools for executing SQL queries, listing tables, describing table schemas, executing migrations, and retrieving full schema DDL on SQLite databases.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-server-databaseshow me all tables"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
mcp-server-database
An MCP (Model Context Protocol) server that provides tools for interacting with relational databases. Supports PostgreSQL, MySQL, and SQLite.
Architecture
graph TB
subgraph Client
style Client fill:#4A90D9,stroke:#2E6BA6,color:#FFFFFF
MCP_Client["MCP Client"]
end
subgraph Server["mcp-server-database"]
style Server fill:#2ECC71,stroke:#1A9B52,color:#FFFFFF
Index["index.ts<br/>MCP Server Entry"]
subgraph Tools
style Tools fill:#F39C12,stroke:#C67D0A,color:#FFFFFF
T1["query"]
T2["list_tables"]
T3["describe_table"]
T4["list_databases"]
T5["execute_migration"]
T6["get_schema"]
end
end
subgraph Databases["Database Engines"]
style Databases fill:#9B59B6,stroke:#7D3C98,color:#FFFFFF
PG["PostgreSQL"]
MY["MySQL"]
SQ["SQLite"]
end
MCP_Client -- "stdio transport" --> Index
Index --> T1 & T2 & T3 & T4 & T5 & T6
T1 --> PG & MY & SQ
T2 --> PG & MY & SQ
T3 --> PG & MY & SQ
T4 --> PG & MY
T5 --> PG & MY & SQ
T6 --> PG & MY & SQRelated MCP server: Universal SQL MCP Server
Installation
npm install
npm run buildConfiguration
Variable | Description | Required |
| Database driver: | Yes |
| Database host | Yes (postgres/mysql) |
| Database port | No |
| Database username | Yes (postgres/mysql) |
| Database password | Yes (postgres/mysql) |
| Database name | Yes |
| Path to SQLite file | Yes (sqlite) |
Usage
Standalone
DB_DRIVER=postgres DB_HOST=localhost DB_USER=admin DB_PASSWORD=secret DB_NAME=mydb npm startDevelopment
npm run devDocker
docker build -t mcp-server-database .
docker run -e DB_DRIVER=postgres -e DB_HOST=host.docker.internal -e DB_USER=admin -e DB_PASSWORD=secret -e DB_NAME=mydb mcp-server-databaseMCP Client Configuration
{
"mcpServers": {
"database": {
"command": "node",
"args": ["dist/index.js"],
"env": {
"DB_DRIVER": "postgres",
"DB_HOST": "localhost",
"DB_PORT": "5432",
"DB_USER": "admin",
"DB_PASSWORD": "secret",
"DB_NAME": "mydb"
}
}
}
}Tool Reference
Tool | Description | Parameters |
| Execute a SQL query |
|
| List all tables | none |
| Describe a table schema |
|
| List databases on the server | none |
| Execute a migration SQL script |
|
| Get full database schema DDL | none |
License
MIT
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/Citadel-Cloud-Management/mcp-server-database'
If you have feedback or need assistance with the MCP directory API, please join our Discord server