Database Server

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Available on NPM:@ahmetbarut/mcp-database-server

# Use with npx (no installation required) npx @ahmetbarut/mcp-database-server # Or install globally npm install -g @ahmetbarut/mcp-database-server

Server starts and Web UI opens athttp://localhost:3693. Add your database connections from the browser.

{ "mcpServers": { "database": { "command": "npx", "args": ["-y", "@ahmetbarut/mcp-database-server"] } } }

{ "mcpServers": { "database": { "command": "npx", "args": ["-y", "@ahmetbarut/mcp-database-server"] } } }

{ "mcpServers": { "database": { "command": "npx", "args": ["-y", "@ahmetbarut/mcp-database-server"], "env": { "WEB_UI_PORT": "4000" } } } }

After starting, open the Web UI in your browser to add database connections.

Execute SQL queries on a database connection with parameterized query support.

{ "connection_name": "my-postgres", "query": "SELECT * FROM users WHERE status = $1", "parameters": ["active"] }

List databases from a specific connection or all configured connections. Supports smart auto-detection when only one connection is active.

{ "connection_name": "my-postgres" }

List all database connections with status and details.

{ "include_credentials": false }

{ "connection_name": "my-postgres" }

All database connections are managed through theWeb UIand stored in a local SQLite database at~/.mcp-database-server/connections.db.

- Host, port, database, username, password
- SSL support (optional)

- Host, port, database, username, password
- SSL support (optional)

# Clone the repository git clone https://github.com/ahmetbarut/mcp-database-server.git cd mcp-database-server # Install dependencies npm install # Development mode (hot-reload) npm run dev # Build npm run build # Run tests npm test # Run tests with coverage npm run test:coverage # Lint npm run lint # Type check npm run type-check

mcp-database-server/ ├── src/ │ ├── index.ts # CLI entry point │ ├── server/ │ │ └── mcp-server.ts # MCP server, tool handlers │ ├── database/ │ │ ├── base.ts # Abstract base driver │ │ ├── factory.ts # Driver factory & connection manager │ │ └── drivers/ # SQLite, PostgreSQL, MySQL drivers │ ├── config/ │ │ ├── settings.ts # Config manager (loads from SQLite store) │ │ └── config-store.ts # SQLite-backed connection storage │ ├── web/ │ │ ├── web-server.ts # HTTP server for Web UI │ │ ├── routes.ts # REST API endpoints │ │ └── ui.ts # Embedded HTML/CSS/JS interface │ ├── types/ # TypeScript types & Zod schemas │ └── utils/ # Logger, exceptions, helpers ├── tests/unit/ # Jest test suites └── dist/ # Compiled output

npx @ahmetbarut/mcp-database-server │ ├── MCPDatabaseServer │ ├── MCP stdio transport (JSON-RPC) │ ├── DatabaseConnectionManager │ └── WebUIServer (http://localhost:3693) │ └── ConnectionConfigStore (~/.mcp-database-server/connections.db) └── SQLite database with connection configs

- Config Storeloads saved connections from local SQLite DB
- Connection Managerinitializes database drivers for each config
- MCP Serverexposes tools via JSON-RPC over stdio
- Web UIprovides browser-based CRUD for connections via REST API

- Parameterized queries— prevents SQL injection
- Credential masking— passwords hidden inlist_connectionsoutput
- Audit logging— all operations logged via Winston
- Input validation— Zod schemas for all configuration

Test Suites: 2 passed, 2 total Tests: 23 passed, 23 total

npm test # Run all tests npm run test:watch # Watch mode npm run test:coverage # Coverage report

- Check if port 3693 is already in use
- Try a different port:WEB_UI_PORT=4000

- Use the "Test Connection" button in Web UI before saving
- Verify database server is running and accessible
- Check credentials and network connectivity
- For PostgreSQL: disable SSL if server doesn't support it

- Ensurenpx @ahmetbarut/mcp-database-serverruns without errors
- Restart the MCP client after config changes
- Check MCP client logs for error details

MIT License - see LICENSE file for details.
- Follow TypeScript coding standards
- Add tests for new functionality
- Update documentation for API changes
- Follow security guidelines

For issues and questions, use theGitHub issue tracker.

Interact with PostgreSQL, MySQL, MariaDB, and SQLite databases using SQLAlchemy.