codelogic-database-impact
Analyze code-database dependencies to assess impacts before implementing changes. Use this tool to identify which code relies on specific database objects or how database changes affect code. Essential for validating AI-suggested modifications or SQL code updates.
Instructions
Analyze impacts between code and database entities. Recommended workflow:
Use this tool before implementing code or database changes
Search for the relevant database entity
Review the impact analysis to understand which code depends on this database object and vice versa Particularly crucial when AI-suggested modifications are being considered or when modifying SQL code.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entity_type | Yes | Type of database entity to search for (column, table, or view) | |
| name | Yes | Name of the database entity to search for | |
| table_or_view | No | Name of the table or view containing the column (required for columns only) |
Input Schema (JSON Schema)
{
"properties": {
"entity_type": {
"description": "Type of database entity to search for (column, table, or view)",
"enum": [
"column",
"table",
"view"
],
"type": "string"
},
"name": {
"description": "Name of the database entity to search for",
"type": "string"
},
"table_or_view": {
"description": "Name of the table or view containing the column (required for columns only)",
"type": "string"
}
},
"required": [
"entity_type",
"name"
],
"type": "object"
}