How do I install the pawsql mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `PAWSQL_API_BASE_URL` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Pawsql MCP Server

PawSQL MCP Server is a SQL optimization service developed based on Spring AI, providing SQL performance analysis and optimization suggestions. It

Local serverstdio

What is the Pawsql MCP Server?

PawSQL MCP Server is a SQL optimization service developed based on Spring AI, providing SQL performance analysis and optimization suggestions. It runs as an MCP

The short version

Supports both workspace and workspace-free optimization modes
Provides SQL rewriting and index optimization suggestions
Visual execution plan analysis (for database-connected workspaces)
Performance evaluation reports

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
enterprise	Enterprise Edition
cloud	Cloud Edition
community	Community Edition

How to install the Pawsql MCP Server

{
  "mcpServers": {
    "pawsql": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PAWSQL_EDITION=<edition>",
        "-e",
        "PAWSQL_API_BASE_URL=<api-url>",
        "-e",
        "PAWSQL_API_EMAIL=<email>",
        "-e",
        "PAWSQL_API_PASSWORD=<password>",
        "pawsql/pawsql-mcp-server:latest"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Example prompts to try

“Use Pawsql MCP to enterprise.”
“Use Pawsql MCP to cloud.”
“Use Pawsql MCP to community.”

Frequently asked questions

PawSQL MCP Server is a SQL optimization service developed based on Spring AI, providing SQL performance analysis and optimization suggestions. It runs as an MCP Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.