Querysharp Postgresql Performance Fixer

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

1. Sign up at Querysharp
2. Add your PostgreSQL database for monitoring
3. 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.

1. Fork the repository
2. Create your feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add some amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. 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: [email protected]

🏷️ Keywords

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