/** * Tool: suggest_schema_optimizations * Returns analysis data about table schema for LLM to suggest optimizations */ export interface SuggestSchemaOptimizationsInput { schema: string; table: string; } export interface ColumnAnalysis { column_name: string; data_type: string; character_maximum_length: number | null; nullability_rate: number; cardinality: number; avg_width: number; is_indexed: boolean; is_foreign_key: boolean; distinct_sample_size: number; } export interface ForeignKeyAnalysis { constraint_name: string; column_name: string; foreign_table: string; foreign_column: string; has_index: boolean; } export interface BloatAnalysis { n_live_tup: number; n_dead_tup: number; bloat_percentage: number; last_vacuum: string | null; last_autovacuum: string | null; last_analyze: string | null; } export interface DataTypeIssue { column_name: string; current_type: string; issue: string; suggestion: string; } export interface SchemaOptimizationsOutput { schema: string; table: string; column_analysis: ColumnAnalysis[]; foreign_keys: ForeignKeyAnalysis[]; bloat_analysis: BloatAnalysis; data_type_issues: DataTypeIssue[]; total_size: string; row_count: number; } /** * Analyzes table schema and returns data for optimization suggestions */ export declare function suggestSchemaOptimizations(input: SuggestSchemaOptimizationsInput): Promise; //# sourceMappingURL=suggestSchemaOptimizations.d.ts.map