MCP 服务器

Multi-Database SQL MCP Server

Enables interaction with SQLite, MySQL, PostgreSQL, and SQL Server databases through tools for connection management, parameterized query execution, and schema inspection.

README

Multi-Database SQL MCP Server

A Model Context Protocol (MCP) server that provides SQL database connectivity for multiple database types including SQLite, MySQL, PostgreSQL, and SQL Server.

Features

Multi-database support: SQLite, MySQL, PostgreSQL, and SQL Server
Connection management: Create, manage, and disconnect multiple database connections
Query execution: Execute SQL queries with parameterized support
Schema inspection: Get table and column information
Type-safe: Built with TypeScript for better development experience

Installation

npm install

Development

# Build the project
npm run build

🔌 MCP Server Integration

To integrate this toolset into your MCP-based system, modify your configuration like this:

{
  "mcpServers": {
    "weather": {
      "command": "node",
      "args": [
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/project/build/index.js"
      ]
    }
  }
}

To integrate this toolset into your MCP-based system, update your configuration to run the Playwright server using a custom npm script:

{
  "mcpServers": {
    "playwright": {
      "command": "npm",
      "args": [
        "run",
        "start:mcp"
      ]
    }
  }
}

✅ Make sure your package.json includes a start:mcp script that points to the correct TypeScript entry file via ts-node.

Example package.json snippet:

"scripts": {
  "start:mcp": "ts-node src/index.ts"
}

This allows you to skip the manual npm run build step during development, making it quicker to iterate and test MCP tools directly from TypeScript source.

Usage

The server supports the following tools:

1. connect_database

Connect to a database with the specified configuration.

Parameters:

connectionId (string, required): Unique identifier for the connection
type (string, required): Database type - 'sqlite', 'mysql', 'postgresql', or 'mssql'
database (string, required): Database name
host (string, optional): Database host (not required for SQLite)
port (number, optional): Database port (not required for SQLite)
username (string, optional): Database username (not required for SQLite)
password (string, optional): Database password (not required for SQLite)
filename (string, optional): SQLite database file path (required for SQLite)
ssl (boolean, optional): Enable SSL connection
trustServerCertificate (boolean, optional): Trust server certificate (MSSQL only)

2. execute_query

Execute a SQL query on a connected database.

Parameters:

connectionId (string, required): Connection identifier
query (string, required): SQL query to execute
parameters (array, optional): Query parameters for parameterized queries

3. get_table_schema

Get schema information for tables.

Parameters:

connectionId (string, required): Connection identifier
tableName (string, optional): Specific table name (if not provided, returns all tables)

4. list_connections

List all active database connections.

Parameters: None

5. disconnect_database

Disconnect from a database.

Parameters:

connectionId (string, required): Connection identifier to disconnect

Database-Specific Notes

SQLite

Requires filename parameter pointing to the database file
No host, port, username, or password required
File will be created if it doesn't exist

MySQL

Default port: 3306
Supports SSL connections
Uses mysql2 driver for Promise-based operations

PostgreSQL

Default port: 5432
Supports SSL connections with rejectUnauthorized: false for development
Uses pg driver

SQL Server (MSSQL)

Default port: 1433
Supports SSL encryption
Use trustServerCertificate: true for self-signed certificates
Uses mssql driver

Example Connections

SQLite

{
  "connectionId": "my-sqlite",
  "type": "sqlite",
  "database": "myapp",
  "filename": "./data/myapp.db"
}

MySQL

{
  "connectionId": "my-mysql",
  "type": "mysql",
  "host": "localhost",
  "port": 3306,
  "database": "myapp",
  "username": "root",
  "password": "password",
  "ssl": false
}

PostgreSQL

{
  "connectionId": "my-postgres",
  "type": "postgresql",
  "host": "localhost",
  "port": 5432,
  "database": "myapp",
  "username": "postgres",
  "password": "password",
  "ssl": false
}

SQL Server

{
  "connectionId": "my-mssql",
  "type": "mssql",
  "host": "localhost",
  "port": 1433,
  "database": "myapp",
  "username": "sa",
  "password": "YourStrong@Passw0rd",
  "ssl": true,
  "trustServerCertificate": true
}

Error Handling

The server includes comprehensive error handling for:

Database connection failures
Query execution errors
Invalid connection IDs
Unsupported database types
Schema inspection errors

All errors are returned with descriptive messages to help with debugging.

Project Structure

src/
├── index.ts           # Main server entry point
├── DatabaseManager.ts # Database connection and query management
├── handlers.ts        # Tool call handlers
├── tools.ts          # Tool definitions
└── types.ts          # TypeScript type definitions