Querysharp

Provides an MCP server that connects to Querysharp to monitor PostgreSQL performance and fetch optimization recommendations.

javascript

2

GitHub Stars

javascript

Language

4 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "weepulse-querysharp-mcp": {
      "command": "npx",
      "args": [
        "querysharp-mcp",
        "--api-key",
        "YOUR_API_KEY"
      ],
      "env": {
        "API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

You run a Querysharp MCP Server to empower AI assistants in your editor to analyze and optimize PostgreSQL performance. This server exposes practical tools to discover your monitored databases, fetch optimization recommendations, and help you apply fixes—all through simple MCP client interactions.

How to use

You connect an MCP client to this server to access two core tools. Use get_projects to list all your Querysharp projects and their databases, then use get_database_fixes to retrieve performance fixes for a specific project. When you’re ready, let the AI guide you through implementing the suggested optimizations.

How to install

Prerequisites before you start: install Node.js 18.0.0 or higher, and ensure you have a Querysharp account with a monitored PostgreSQL database.

# Step 1: Install Node.js (if not already installed)
# Follow the official Node.js installer for your platform

# Step 2: Install and run the MCP server locally using npx
# Use your API key from Querysharp when prompted
npx querysharp-mcp --api-key YOUR_API_KEY

# Step 3: If you prefer a global installation, install and run directly
# Note: You still provide the API key when starting
querysharp-mcp --api-key YOUR_API_KEY

Additional notes

The MCP server examples include two local initialization methods. You can run them with either the npx-based approach or a direct command that assumes a globally installed package. Each method requires your API key to authorize requests to Querysharp.

Available tools

get_projects

Lists all monitored Querysharp projects along with their database tables.

get_database_fixes

Fetches performance fixes for a specific project, including missing index recommendations with SQL commands and query optimization suggestions. Also provides severity levels (Low, Medium, High, Critical).