/**
 * Database Migration Runner
 * Handles schema creation, updates, and cleanup
 */
export declare class DatabaseMigrator {
    private pool;
    constructor(connectionString?: string);
    /**
     * Run migrations to create schema
     */
    up(): Promise<void>;
    /**
     * Rollback migrations
     */
    down(): Promise<void>;
    /**
     * Cleanup old records (retention policy)
     * Should be run as a cron job daily
     */
    cleanup(): Promise<number | null>;
    /**
     * Insert metrics snapshot
     */
    insertMetrics(metrics: any): Promise<any>;
    /**
     * Insert agent history record
     */
    insertAgentHistory(agentId: string, agentName: string, status: string, data: any): Promise<any>;
    /**
     * Insert cache entry
     */
    insertCacheEntry(queryHash: string, queryText: string, tokensSaved: number, costSaved: number): Promise<any>;
    /**
     * Insert event log record
     */
    insertEvent(eventData: {
        eventId: string;
        eventType: string;
        agentId?: string;
        queryHash?: string;
        latencyMs?: number;
        tokensSaved?: number;
        costSaved?: number;
        metadata?: any;
    }): Promise<any>;
    /**
     * Get metrics for date range
     */
    getMetricsHistory(daysBack?: number): Promise<any[]>;
    /**
     * Get top cached queries
     */
    getTopQueries(limit?: number): Promise<any[]>;
    /**
     * Close database connection
     */
    close(): Promise<void>;
}
export default DatabaseMigrator;
//# sourceMappingURL=database.d.ts.map