Postgres MCP

MIT License

228

Overview InspectNew Schema Related Servers Reviews Score

get_top_queries

Identify and analyze the slowest SQL queries by execution time using data from the 'pg_stat_statements' extension. Specify the number of queries and sort by total or mean execution time to optimize database performance.

Instructions

Reports the slowest SQL queries based on execution time, using data from the 'pg_stat_statements' extension.

Input Schema

Name	Required	Description	Default
`limit`	No	Number of slow queries to return
`sort_by`	No	Sort criteria: 'total' for total execution time or 'mean' for mean execution time per call	mean

Input Schema (JSON Schema)

{
  "properties": {
    "limit": {
      "default": 10,
      "description": "Number of slow queries to return",
      "title": "Limit",
      "type": "integer"
    },
    "sort_by": {
      "default": "mean",
      "description": "Sort criteria: 'total' for total execution time or 'mean' for mean execution time per call",
      "title": "Sort By",
      "type": "string"
    }
  },
  "title": "get_top_queriesArguments",
  "type": "object"
}

Install Server

HTTP connection URL

Related Tools

explain_query
@crystaldba/postgres-mcp
optimize_sql
@madhukarkumar/singlestore-mcp-server
analyze_db_health
@crystaldba/postgres-mcp
analyze_database
@nahmanmate/postgresql-mcp-server
steampipe_query
@turbot/steampipe-mcp
execute_sql
@crystaldba/postgres-mcp

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/crystaldba/postgres-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server