Database Operations Manager

Usage Examples

Query Optimization

from scripts.query_builder import QueryBuilder

builder = QueryBuilder()
optimized = builder.optimize_query(
    "SELECT * FROM users WHERE age > 25",
    database_type="postgresql"
)
print(f"Original cost: {optimized['original_cost']}")
print(f"Optimized cost: {optimized['optimized_cost']}")

Schema Analysis

from scripts.schema_analyzer import SchemaAnalyzer