apisql-mcp

Overview

apiSQL-MCP is a versatile MCP server that connects to various database systems including MySQL, PostgreSQL, SQL Server, Oracle, SQLite, StarRocks, DuckDB, and others compatible with JDBC. It offers dynamic data source switching without restarting the server, secure access through apiSQL gateway, and comprehensive SQL support including DDL and DML operations. The server supports multiple transport modes including STDIO and Streamable HTTP.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_sql

  Execute SQL queries across multiple databases with dynamic data source switching

  Try:Show me all users from the databaseTry:What are the top 10 customers by revenue?Try:List all tables starting with DW

Comparable tools

Installation

npm install -g apisql-mcp
# or run directly with
npx -y apisql-mcp

{
  "mcpServers": {
    "apisql-mcp": {
      "command": "npx",
      "args": ["-y", "apisql-mcp"],
      "env": {
        "APISQL_MCP_API_URL": "https://open.apisql.cn/api/mytest/$sudb",
        "APISQL_MCP_API_KEY": "Bearer sk-your-api-key",
        "APISQL_MCP_DS": "mysql"
      }
    }
  }
}

FAQ

How many databases can I connect with this MCP server?

You can connect to any number of databases supported by apiSQL platform, including MySQL, PostgreSQL, SQL Server, Oracle, SQLite, StarRocks, DuckDB, and others with JDBC compatibility.

Is it possible to switch databases without restarting the server?

Yes, the apiSQL-MCP server supports dynamic data source switching without requiring a restart. You can specify different data sources in your SQL queries.

Compare apisql-mcp with