/** * postgres-mcp - pg_cron Tool Schemas * * Input validation schemas for scheduled job management. */ import { z } from "zod"; /** * Schedule for cron jobs. Supports: * - Standard cron: "0 10 * * *" (daily at 10:00) * - Interval: "30 seconds" (every 30 seconds) * - Special: "0 12 $ * *" (noon on last day of month) * * Accepts 'name' as alias for 'jobName'. * Accepts 'sql' or 'query' as alias for 'command'. * Uses base schema for MCP exposure and transform schema for validation. */ export declare const CronCreateExtensionSchemaBase: z.ZodObject<{}, z.core.$strip>; export declare const CronCreateExtensionSchema: z.ZodPreprocess>; export declare const CronScheduleSchemaBase: z.ZodObject<{ schedule: z.ZodOptional; command: z.ZodOptional; sql: z.ZodOptional; query: z.ZodOptional; jobName: z.ZodOptional; name: z.ZodOptional; }, z.core.$strip>; export declare const CronScheduleSchema: z.ZodPreprocess; command: z.ZodOptional; sql: z.ZodOptional; query: z.ZodOptional; jobName: z.ZodOptional; name: z.ZodOptional; }, z.core.$strip>, z.ZodTransform<{ schedule: string; command: string; jobName: string | undefined; }, { schedule?: string | undefined; command?: string | undefined; sql?: string | undefined; query?: string | undefined; jobName?: string | undefined; name?: string | undefined; }>>>; /** * Schedule for cross-database cron jobs. * Accepts 'name' as alias for 'jobName'. * Accepts 'sql'/'query' as alias for 'command'. * Accepts 'db' as alias for 'database'. * Uses base schema for MCP exposure and transform schema for validation. */ export declare const CronScheduleInDatabaseSchemaBase: z.ZodObject<{ jobName: z.ZodOptional; name: z.ZodOptional; schedule: z.ZodOptional; command: z.ZodOptional; sql: z.ZodOptional; query: z.ZodOptional; database: z.ZodOptional; db: z.ZodOptional; username: z.ZodOptional; active: z.ZodOptional; }, z.core.$strip>; export declare const CronScheduleInDatabaseSchema: z.ZodPreprocess; name: z.ZodOptional; schedule: z.ZodOptional; command: z.ZodOptional; sql: z.ZodOptional; query: z.ZodOptional; database: z.ZodOptional; db: z.ZodOptional; username: z.ZodOptional; active: z.ZodOptional; }, z.core.$strip>, z.ZodTransform<{ jobName: string | undefined; schedule: string; command: string; database: string; username: string | undefined; active: boolean | undefined; }, { jobName?: string | undefined; name?: string | undefined; schedule?: string | undefined; command?: string | undefined; sql?: string | undefined; query?: string | undefined; database?: string | undefined; db?: string | undefined; username?: string | undefined; active?: boolean | undefined; }>>>; export declare const CronUnscheduleSchemaBase: z.ZodObject<{ jobId: z.ZodOptional>; jobName: z.ZodOptional; name: z.ZodOptional; }, z.core.$strip>; export declare const CronUnscheduleSchema: z.ZodPipe>; jobName: z.ZodOptional; name: z.ZodOptional; }, z.core.$strip>, z.ZodTransform<{ jobId: number | undefined; jobName: string | undefined; }, { jobId?: string | number | undefined; jobName?: string | undefined; name?: string | undefined; }>>; export declare const CronAlterJobSchemaBase: z.ZodObject<{ jobId: z.ZodOptional>; jobName: z.ZodOptional; name: z.ZodOptional; schedule: z.ZodOptional; command: z.ZodOptional; database: z.ZodOptional; username: z.ZodOptional; active: z.ZodOptional; }, z.core.$strip>; export declare const CronAlterJobSchema: z.ZodPipe>; jobName: z.ZodOptional; name: z.ZodOptional; schedule: z.ZodOptional; command: z.ZodOptional; database: z.ZodOptional; username: z.ZodOptional; active: z.ZodOptional; }, z.core.$strip>, z.ZodTransform<{ jobId: number | undefined; jobName: string | undefined; name?: string | undefined; schedule?: string | undefined; command?: string | undefined; database?: string | undefined; username?: string | undefined; active?: boolean | undefined; }, { jobId?: string | number | undefined; jobName?: string | undefined; name?: string | undefined; schedule?: string | undefined; command?: string | undefined; database?: string | undefined; username?: string | undefined; active?: boolean | undefined; }>>; export declare const CronListJobsSchemaBase: z.ZodObject<{ active: z.ZodOptional; limit: z.ZodOptional>; compact: z.ZodOptional; }, z.core.$strip>; export declare const CronListJobsSchema: z.ZodDefault; limit: z.ZodOptional>>; compact: z.ZodDefault>; }, z.core.$strip>>; export declare const CronJobRunDetailsSchemaBase: z.ZodObject<{ jobId: z.ZodOptional>; jobName: z.ZodOptional; status: z.ZodOptional; limit: z.ZodOptional>; compact: z.ZodOptional; }, z.core.$strip>; export declare const CronJobRunDetailsSchema: z.ZodPipe>; jobName: z.ZodOptional; status: z.ZodOptional; limit: z.ZodOptional>>; compact: z.ZodDefault>; }, z.core.$strip>>, z.ZodTransform<{ jobId: number | undefined; compact: boolean; jobName?: string | undefined; status?: string | undefined; limit?: number | undefined; }, { compact: boolean; jobId?: string | number | undefined; jobName?: string | undefined; status?: string | undefined; limit?: number | undefined; }>>; export declare const CronCleanupHistorySchemaBase: z.ZodObject<{ olderThanDays: z.ZodOptional>; days: z.ZodOptional>; jobId: z.ZodOptional>; }, z.core.$strip>; export declare const CronCleanupHistorySchema: z.ZodPreprocess>>; days: z.ZodOptional>>; jobId: z.ZodOptional; }, z.core.$strip>, z.ZodTransform<{ olderThanDays: number | undefined; jobId: number | undefined; }, { olderThanDays?: number | undefined; days?: number | undefined; jobId?: unknown; }>>>; /** * Output schema for pg_cron_create_extension */ export declare const CronCreateExtensionOutputSchema: z.ZodObject<{ success: z.ZodBoolean; message: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_schedule */ export declare const CronScheduleOutputSchema: z.ZodObject<{ success: z.ZodBoolean; jobId: z.ZodOptional>; jobName: z.ZodOptional>; schedule: z.ZodOptional; command: z.ZodOptional; message: z.ZodOptional; hint: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_schedule_in_database */ export declare const CronScheduleInDatabaseOutputSchema: z.ZodObject<{ success: z.ZodBoolean; jobId: z.ZodOptional>; jobName: z.ZodOptional; schedule: z.ZodOptional; command: z.ZodOptional; database: z.ZodOptional; username: z.ZodOptional>; active: z.ZodOptional; message: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_unschedule */ export declare const CronUnscheduleOutputSchema: z.ZodObject<{ success: z.ZodBoolean; jobId: z.ZodOptional>; jobName: z.ZodOptional>; usedIdentifier: z.ZodOptional>; warning: z.ZodOptional; message: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_alter_job */ export declare const CronAlterJobOutputSchema: z.ZodObject<{ success: z.ZodBoolean; jobId: z.ZodOptional; changes: z.ZodOptional; command: z.ZodOptional; database: z.ZodOptional; username: z.ZodOptional; active: z.ZodOptional; }, z.core.$strip>>; message: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_list_jobs */ export declare const CronListJobsOutputSchema: z.ZodObject<{ success: z.ZodBoolean; jobs: z.ZodOptional; jobname: z.ZodNullable; schedule: z.ZodString; command: z.ZodString; nodename: z.ZodNullable; nodeport: z.ZodNullable; database: z.ZodString; username: z.ZodString; active: z.ZodBoolean; }, z.core.$strip>>>; count: z.ZodOptional; truncated: z.ZodOptional; totalCount: z.ZodOptional; hint: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_job_run_details */ export declare const CronJobRunDetailsOutputSchema: z.ZodObject<{ success: z.ZodBoolean; runs: z.ZodOptional; jobid: z.ZodNullable; job_pid: z.ZodNullable; database: z.ZodString; username: z.ZodString; command: z.ZodString; status: z.ZodString; return_message: z.ZodNullable; start_time: z.ZodNullable>; end_time: z.ZodNullable>; }, z.core.$strip>>>; count: z.ZodOptional; truncated: z.ZodOptional; totalCount: z.ZodOptional; summary: z.ZodOptional>; error: z.ZodOptional; }, z.core.$strip>; /** * Output schema for pg_cron_cleanup_history */ export declare const CronCleanupHistoryOutputSchema: z.ZodObject<{ success: z.ZodBoolean; deletedCount: z.ZodOptional; olderThanDays: z.ZodOptional; jobId: z.ZodOptional>; message: z.ZodOptional; error: z.ZodOptional; }, z.core.$strip>; //# sourceMappingURL=cron.d.ts.map