pg_analyze_database
Analyze PostgreSQL database configuration, performance, and security to optimize database settings and identify potential issues for improved efficiency.
Instructions
Analyze PostgreSQL database configuration and performance
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| analysisType | No | Type of analysis to perform | |
| connectionString | No | PostgreSQL connection string (optional if POSTGRES_CONNECTION_STRING environment variable or --connection-string CLI option is set) |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"analysisType": {
"description": "Type of analysis to perform",
"enum": [
"configuration",
"performance",
"security"
],
"type": "string"
},
"connectionString": {
"description": "PostgreSQL connection string (optional if POSTGRES_CONNECTION_STRING environment variable or --connection-string CLI option is set)",
"type": "string"
}
},
"type": "object"
}