Querysharp MCP Server

A Model Context Protocol (MCP) server for Querysharp, enabling AI assistants to help you analyze and optimize your PostgreSQL database performance directly from your code editor.

🚀 Quick Start

Setup in Cursor/Claude

Add to your MCP configuration file:

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

For global installation:

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

🎯 What It Does

Querysharp is a database performance monitoring tool that identifies potential performance issues and suggests optimizations. This MCP server allows AI assistants like Claude (in Cursor) to:

🔍 Get your database projects - Retrieve all monitored databases
🛠️ Fetch performance fixes - Get specific optimization recommendations
🚀 Apply optimizations - Let AI help implement the suggested fixes

🛠️ Features

Available Tools

get_projects - Lists all your Querysharp projects with their database tables
get_database_fixes - Retrieves performance fixes for a specific project, including:
- Missing index recommendations with SQL commands
- Query rewrite suggestions for better performance
- Severity levels (Low, Medium, High, Critical)

🔧 Requirements

Node.js: 18.0.0 or higher
Querysharp Account: Free signup at querysharp.com
PostgreSQL Database: Connected to Querysharp for monitoring

🔧 Getting Your API Key

Sign up at Querysharp
Add your PostgreSQL database for monitoring
Get your API key from the dashboard

💬 Usage Examples

Once configured, you can ask your AI assistant questions like:

"What database performance issues do I have?"
"Show me the missing indexes for my production database"
"Help me optimize my slow queries"
"Fix my database performance problems"

Example Interaction

You: "Help me fix my database performance"

AI: Let me check your Querysharp projects and get the performance fixes...

[AI calls get_projects tool]
[AI calls get_database_fixes tool for your project]

AI: I found 3 performance issues in your database:

1. **Missing Index on users.email** (HIGH severity)
   - Table: users
   - Suggested SQL: `CREATE INDEX idx_users_email ON users(email);`
   
2. **Slow JOIN Query** (MEDIUM severity)  
   - Original: `SELECT * FROM orders JOIN users ON...`
   - Optimized: `SELECT o.id, u.name FROM orders o JOIN users u ON...`

Would you like me to help you implement these fixes?

🤝 Contributing

We welcome contributions! Please see our Contributing Guide for details.

Fork the repository
Create your feature branch (git checkout -b feature/amazing-feature)
Commit your changes (git commit -m 'Add some amazing feature')
Push to the branch (git push origin feature/amazing-feature)
Open a Pull Request

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

License Scope

What this MIT license covers:

✅ This MCP server code and implementation
✅ All code in this repository

What this license does NOT cover:

❌ Querysharp's main database monitoring service
❌ Querysharp's proprietary algorithms and analysis
❌ Querysharp's web dashboard and API backend
❌ Any Querysharp intellectual property
❌ Anything outside of this repository

Note: This MCP server is a client that connects to Querysharp's API service. You still need a valid Querysharp account and API key to use this tool. Querysharp's terms of service apply to your use of their API and service.

🔗 Links

🌐 Website: querysharp.com
🐛 Issues: GitHub Issues
💬 Support: thomas@weepulse.fr

🏷️ Keywords

mcp, model-context-protocol, database, performance, postgresql, querysharp, optimization, sql, missing-indexes, query-optimization, cursor, claude