analyze_database_queries

Analyze database queries in code for performance, security, and best practices to identify issues and assess technical debt.

Instructions

Analyze database queries for performance, security, and best practices in code files or entire projects

WORKFLOW: Perfect for understanding complex code, identifying issues, and technical debt assessment TIP: Use Desktop Commander to read files, then pass content here for analysis SAVES: Claude context for strategic decisions

Input Schema

Name	Required	Description	Default
`analysisDepth`	No	Level of analysis detail	detailed
`analysisType`	No	Type of database analysis to perform	comprehensive
`code`	No	The code to analyze for database queries (for single-file analysis)
`context`	No	Database and framework context for specialized analysis
`filePath`	No	Path to single file to analyze for database queries
`files`	No	Array of specific file paths (for multi-file analysis)
`language`	No	Programming language	php
`maxDepth`	No	Maximum directory depth for multi-file discovery (1-5)
`projectPath`	No	Path to project root (for multi-file database analysis)

Input Schema (JSON Schema)

{
  "properties": {
    "analysisDepth": {
      "default": "detailed",
      "description": "Level of analysis detail",
      "enum": [
        "basic",
        "detailed",
        "comprehensive"
      ],
      "type": "string"
    },
    "analysisType": {
      "default": "comprehensive",
      "description": "Type of database analysis to perform",
      "enum": [
        "security",
        "performance",
        "best-practices",
        "comprehensive"
      ],
      "type": "string"
    },
    "code": {
      "description": "The code to analyze for database queries (for single-file analysis)",
      "type": "string"
    },
    "context": {
      "description": "Database and framework context for specialized analysis",
      "type": "object"
    },
    "filePath": {
      "description": "Path to single file to analyze for database queries",
      "type": "string"
    },
    "files": {
      "description": "Array of specific file paths (for multi-file analysis)",
      "type": "array"
    },
    "language": {
      "default": "php",
      "description": "Programming language",
      "type": "string"
    },
    "maxDepth": {
      "default": 3,
      "description": "Maximum directory depth for multi-file discovery (1-5)",
      "type": "number"
    },
    "projectPath": {
      "description": "Path to project root (for multi-file database analysis)",
      "type": "string"
    }
  },
  "required": [],
  "type": "object"
}

Houtini-lm

analyze_database_queries

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Houtini-lm

Related Tools

MCP directory API