import { Client } from "pg";
import * as z from "zod";
/** Declares a named PostgreSQL account binding for an automation. */
export declare const postgresAccount: (binding?: string, authorizationHints?: import("../..").AccountAuthorizationHint<"postgres">[] | undefined) => import("../..").IntegrationAccountReference<"postgres">;
/**
 * Runs one parameterized statement in a provider-enforced read-only
 * transaction.
 *
 * A fresh connection is used for each action invocation. Results retain
 * provider command and field metadata alongside the returned rows.
 */
export declare const runPostgresQuery: import("../..").DefinedAction<z.ZodObject<{
    parameters: z.ZodOptional<z.ZodArray<z.ZodUnion<readonly [z.ZodJSONSchema, z.ZodBigInt, z.ZodDate, z.ZodCustom<Uint8Array<ArrayBuffer>, Uint8Array<ArrayBuffer>>]>>>;
    sql: z.ZodString;
}, z.core.$strip>, z.ZodObject<{
    command: z.ZodString;
    fields: z.ZodArray<z.ZodObject<{
        columnId: z.ZodNumber;
        dataTypeId: z.ZodNumber;
        dataTypeModifier: z.ZodNumber;
        dataTypeSize: z.ZodNumber;
        format: z.ZodString;
        name: z.ZodString;
        tableId: z.ZodNumber;
    }, z.core.$strip>>;
    rowCount: z.ZodNullable<z.ZodNumber>;
    rows: z.ZodArray<z.ZodRecord<z.ZodString, z.ZodOptional<z.ZodCustom<import("@automate.ax/codec").Encodable, import("@automate.ax/codec").Encodable>>>>;
}, z.core.$strip>, "postgres", false, never>;
/**
 * Executes one parameterized PostgreSQL statement in its own transaction.
 *
 * Use `runPostgresQuery` for provider-enforced read-only work and this action
 * for statements that can change data or database objects.
 */
export declare const executePostgresStatement: import("../..").DefinedAction<z.ZodObject<{
    parameters: z.ZodOptional<z.ZodArray<z.ZodUnion<readonly [z.ZodJSONSchema, z.ZodBigInt, z.ZodDate, z.ZodCustom<Uint8Array<ArrayBuffer>, Uint8Array<ArrayBuffer>>]>>>;
    sql: z.ZodString;
}, z.core.$strip>, z.ZodObject<{
    command: z.ZodString;
    fields: z.ZodArray<z.ZodObject<{
        columnId: z.ZodNumber;
        dataTypeId: z.ZodNumber;
        dataTypeModifier: z.ZodNumber;
        dataTypeSize: z.ZodNumber;
        format: z.ZodString;
        name: z.ZodString;
        tableId: z.ZodNumber;
    }, z.core.$strip>>;
    rowCount: z.ZodNullable<z.ZodNumber>;
    rows: z.ZodArray<z.ZodRecord<z.ZodString, z.ZodOptional<z.ZodCustom<import("@automate.ax/codec").Encodable, import("@automate.ax/codec").Encodable>>>>;
}, z.core.$strip>, "postgres", false, never>;
/**
 * Executes ordered parameterized statements in one PostgreSQL transaction.
 *
 * The transaction rolls back after the first statement failure. Transaction
 * control statements are rejected because this action owns the boundary.
 */
export declare const runPostgresTransaction: import("../..").DefinedAction<z.ZodObject<{
    statements: z.ZodArray<z.ZodObject<{
        parameters: z.ZodOptional<z.ZodArray<z.ZodUnion<readonly [z.ZodJSONSchema, z.ZodBigInt, z.ZodDate, z.ZodCustom<Uint8Array<ArrayBuffer>, Uint8Array<ArrayBuffer>>]>>>;
        sql: z.ZodString;
    }, z.core.$strip>>;
}, z.core.$strip>, z.ZodObject<{
    results: z.ZodArray<z.ZodObject<{
        command: z.ZodString;
        fields: z.ZodArray<z.ZodObject<{
            columnId: z.ZodNumber;
            dataTypeId: z.ZodNumber;
            dataTypeModifier: z.ZodNumber;
            dataTypeSize: z.ZodNumber;
            format: z.ZodString;
            name: z.ZodString;
            tableId: z.ZodNumber;
        }, z.core.$strip>>;
        rowCount: z.ZodNullable<z.ZodNumber>;
        rows: z.ZodArray<z.ZodRecord<z.ZodString, z.ZodOptional<z.ZodCustom<import("@automate.ax/codec").Encodable, import("@automate.ax/codec").Encodable>>>>;
    }, z.core.$strip>>;
}, z.core.$strip>, "postgres", false, never>;
/** PostgreSQL callables. */
export declare const postgres: {
    execute: import("../..").DefinedAction<z.ZodObject<{
        parameters: z.ZodOptional<z.ZodArray<z.ZodUnion<readonly [z.ZodJSONSchema, z.ZodBigInt, z.ZodDate, z.ZodCustom<Uint8Array<ArrayBuffer>, Uint8Array<ArrayBuffer>>]>>>;
        sql: z.ZodString;
    }, z.core.$strip>, z.ZodObject<{
        command: z.ZodString;
        fields: z.ZodArray<z.ZodObject<{
            columnId: z.ZodNumber;
            dataTypeId: z.ZodNumber;
            dataTypeModifier: z.ZodNumber;
            dataTypeSize: z.ZodNumber;
            format: z.ZodString;
            name: z.ZodString;
            tableId: z.ZodNumber;
        }, z.core.$strip>>;
        rowCount: z.ZodNullable<z.ZodNumber>;
        rows: z.ZodArray<z.ZodRecord<z.ZodString, z.ZodOptional<z.ZodCustom<import("@automate.ax/codec").Encodable, import("@automate.ax/codec").Encodable>>>>;
    }, z.core.$strip>, "postgres", false, never>;
    query: import("../..").DefinedAction<z.ZodObject<{
        parameters: z.ZodOptional<z.ZodArray<z.ZodUnion<readonly [z.ZodJSONSchema, z.ZodBigInt, z.ZodDate, z.ZodCustom<Uint8Array<ArrayBuffer>, Uint8Array<ArrayBuffer>>]>>>;
        sql: z.ZodString;
    }, z.core.$strip>, z.ZodObject<{
        command: z.ZodString;
        fields: z.ZodArray<z.ZodObject<{
            columnId: z.ZodNumber;
            dataTypeId: z.ZodNumber;
            dataTypeModifier: z.ZodNumber;
            dataTypeSize: z.ZodNumber;
            format: z.ZodString;
            name: z.ZodString;
            tableId: z.ZodNumber;
        }, z.core.$strip>>;
        rowCount: z.ZodNullable<z.ZodNumber>;
        rows: z.ZodArray<z.ZodRecord<z.ZodString, z.ZodOptional<z.ZodCustom<import("@automate.ax/codec").Encodable, import("@automate.ax/codec").Encodable>>>>;
    }, z.core.$strip>, "postgres", false, never>;
    transaction: import("../..").DefinedAction<z.ZodObject<{
        statements: z.ZodArray<z.ZodObject<{
            parameters: z.ZodOptional<z.ZodArray<z.ZodUnion<readonly [z.ZodJSONSchema, z.ZodBigInt, z.ZodDate, z.ZodCustom<Uint8Array<ArrayBuffer>, Uint8Array<ArrayBuffer>>]>>>;
            sql: z.ZodString;
        }, z.core.$strip>>;
    }, z.core.$strip>, z.ZodObject<{
        results: z.ZodArray<z.ZodObject<{
            command: z.ZodString;
            fields: z.ZodArray<z.ZodObject<{
                columnId: z.ZodNumber;
                dataTypeId: z.ZodNumber;
                dataTypeModifier: z.ZodNumber;
                dataTypeSize: z.ZodNumber;
                format: z.ZodString;
                name: z.ZodString;
                tableId: z.ZodNumber;
            }, z.core.$strip>>;
            rowCount: z.ZodNullable<z.ZodNumber>;
            rows: z.ZodArray<z.ZodRecord<z.ZodString, z.ZodOptional<z.ZodCustom<import("@automate.ax/codec").Encodable, import("@automate.ax/codec").Encodable>>>>;
        }, z.core.$strip>>;
    }, z.core.$strip>, "postgres", false, never>;
};
/**
 * Creates a PostgreSQL client from a resolved integration secret.
 *
 * Custom actions can use this helper when they need COPY, cursors, prepared
 * session reuse, advisory locks, or another provider feature beyond the
 * packaged actions.
 *
 * @param secret - Validated PostgreSQL integration secret.
 */
export declare function getPostgresClient(secret: Record<string, unknown>): Client;
//# sourceMappingURL=index.d.ts.map