{"version":3,"file":"get-table-schemas.cjs","names":["z","action"],"sources":["../../src/actions/get-table-schemas.ts"],"sourcesContent":["import type { AppAction } from \"@keystrokehq/keystroke/app\";\nimport { z } from \"zod\";\n\nimport { action } from \"../action\";\nimport { supabase } from \"../app\";\n\nexport const SupabaseGetTableSchemasInput = z.object({\n  project_ref: z.string().describe(\"The unique reference ID of the Supabase project. This is visible in your Supabase project URL (e.g., https://supabase.com/dashboard/project/{project_ref}).\"),\n  table_names: z.array(z.string()).describe(\"List of table names to retrieve schemas for. At least one table name is required (empty lists are not allowed). Tables can be from different schemas (e.g., 'public.users', 'operations.call_queue_items'). Without schema prefix, 'public' is assumed. Maximum 20 tables per request.\"),\n  include_indexes: z.boolean().default(true).describe(\"Whether to include index information in the response\").optional(),\n  exclude_null_values: z.boolean().default(true).describe(\"Whether to exclude properties with null values from the response for cleaner output\").optional(),\n  include_relationships: z.boolean().default(true).describe(\"Whether to include foreign key relationships in the response\").optional(),\n}).describe(\"Request schema for retrieving table schemas from Supabase database.\");\nconst SupabaseGetTableSchemas_TableNotFoundErrorSchema = z.object({\n  error: z.string().describe(\"Error message explaining why the table wasn't found\").nullable(),\n  table_name: z.string().describe(\"The table name that was requested\").nullable(),\n  suggestions: z.array(z.string()).describe(\"Suggested table names that might be what the user is looking for\").nullable().optional(),\n}).passthrough().describe(\"Information about a table that wasn't found.\");\nconst SupabaseGetTableSchemas_MetaColumnForeignKeySchema = z.object({\n  match: z.string().nullable().optional(),\n  table: z.string().nullable(),\n  column: z.string().nullable(),\n  schema: z.string().nullable().optional(),\n  on_delete: z.string().nullable().optional(),\n  on_update: z.string().nullable().optional(),\n  deferrable: z.boolean().nullable().optional(),\n  initially_deferred: z.boolean().nullable().optional(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaColumnSchema = z.object({\n  id: z.number().int().nullable(),\n  name: z.string().nullable(),\n  enums: z.array(z.string()),\n  attnum: z.number().int().nullable(),\n  format: z.string().nullable().optional(),\n  comment: z.string().nullable().optional(),\n  computed: z.boolean().nullable().optional(),\n  collation: z.string().nullable().optional(),\n  data_type: z.string().nullable(),\n  is_unique: z.boolean().nullable(),\n  max_length: z.number().int().nullable().optional(),\n  foreign_key: SupabaseGetTableSchemas_MetaColumnForeignKeySchema.nullable().optional(),\n  is_identity: z.boolean().nullable(),\n  is_nullable: z.boolean().nullable(),\n  is_generated: z.boolean().nullable(),\n  is_updatable: z.boolean().nullable(),\n  default_value: z.string().nullable().optional(),\n  numeric_scale: z.number().int().nullable().optional(),\n  is_primary_key: z.boolean().nullable().optional(),\n  ordinal_position: z.number().int().nullable(),\n  numeric_precision: z.number().int().nullable().optional(),\n  datetime_precision: z.number().int().nullable().optional(),\n  identity_generation: z.string().nullable().optional(),\n  generation_expression: z.string().nullable().optional(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaIndexSchema = z.object({\n  name: z.string().nullable(),\n  method: z.string().nullable().optional(),\n  columns: z.array(z.string()).nullable().optional(),\n  is_unique: z.boolean().nullable(),\n  definition: z.string().nullable(),\n  is_primary: z.boolean().nullable(),\n  tablespace: z.string().nullable().optional(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaPolicySchema = z.object({\n  name: z.string().nullable(),\n  roles: z.array(z.string()).nullable().optional(),\n  using: z.string().nullable().optional(),\n  command: z.string().nullable(),\n  permissive: z.boolean().nullable(),\n  with_check: z.string().nullable().optional(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaConstraintReferenceSchema = z.object({\n  match: z.string().nullable().optional(),\n  table: z.string().nullable(),\n  schema: z.string().nullable().optional(),\n  columns: z.array(z.string()),\n  on_delete: z.string().nullable().optional(),\n  on_update: z.string().nullable().optional(),\n  deferrable: z.boolean().nullable().optional(),\n  initially_deferred: z.boolean().nullable().optional(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaConstraintSchema = z.object({\n  name: z.string().nullable(),\n  type: z.string().nullable(),\n  columns: z.array(z.string()).nullable().optional(),\n  definition: z.string().nullable().optional(),\n  references: SupabaseGetTableSchemas_MetaConstraintReferenceSchema.nullable().optional(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaForeignKeySummarySchema = z.object({\n  on_delete: z.string().nullable().optional(),\n  on_update: z.string().nullable().optional(),\n  target_table: z.string().nullable(),\n  source_column: z.string().nullable(),\n  target_column: z.string().nullable(),\n  target_schema: z.string().nullable(),\n  constraint_name: z.string().nullable(),\n}).passthrough();\nconst SupabaseGetTableSchemas_MetaTableSchema = z.object({\n  id: z.number().int().nullable(),\n  name: z.string().nullable(),\n  bytes: z.number().int().nullable(),\n  owner: z.string().nullable().optional(),\n  schema: z.string().nullable().optional(),\n  columns: z.array(SupabaseGetTableSchemas_MetaColumnSchema),\n  comment: z.string().nullable().optional(),\n  indexes: z.array(SupabaseGetTableSchemas_MetaIndexSchema).nullable().optional(),\n  policies: z.array(SupabaseGetTableSchemas_MetaPolicySchema).nullable().optional(),\n  unlogged: z.boolean().nullable(),\n  full_name: z.string().nullable(),\n  row_count: z.number().int().nullable(),\n  partitions: z.array(z.record(z.string(), z.unknown())).nullable().optional(),\n  rls_forced: z.boolean().nullable(),\n  table_name: z.string().nullable(),\n  tablespace: z.string().nullable().optional(),\n  constraints: z.array(SupabaseGetTableSchemas_MetaConstraintSchema).nullable().optional(),\n  partitioned: z.boolean().nullable().optional(),\n  rls_enabled: z.boolean().nullable(),\n  schema_name: z.string().nullable(),\n  toast_relid: z.number().int().nullable().optional(),\n  foreign_keys: z.array(SupabaseGetTableSchemas_MetaForeignKeySummarySchema).nullable().optional(),\n  parent_table: z.record(z.string(), z.unknown()).nullable().optional(),\n  primary_keys: z.array(z.string()),\n  replica_identity: z.string().nullable(),\n}).passthrough();\nexport const SupabaseGetTableSchemasOutput = z.object({\n  errors: z.array(SupabaseGetTableSchemas_TableNotFoundErrorSchema).describe(\"List of errors encountered when fetching tables. Contains details about tables that could not be retrieved due to errors (connectivity issues, authentication failures, tables not found, etc.).\").nullable().optional(),\n  tables: z.array(SupabaseGetTableSchemas_MetaTableSchema).describe(\"List of database tables with full schema metadata as returned by Supabase Postgres Meta API (GET /tables).\"),\n  total_found: z.number().int().describe(\"Total number of tables found that match the query\").nullable(),\n  total_requested: z.number().int().describe(\"Number of tables requested (limit) for this response\").nullable(),\n}).passthrough().describe(\"Response payload containing Supabase table schema definitions and summary counts\");\n\nexport const supabaseGetTableSchemas: AppAction<\n  typeof SupabaseGetTableSchemasInput,\n  typeof SupabaseGetTableSchemasOutput,\n  typeof supabase.credential\n> = action(\"SUPABASE_GET_TABLE_SCHEMAS\", {\n  slug: \"supabase-get-table-schemas\",\n  name: \"Get Table Schemas\",\n  description: \"Retrieves column details, types, and constraints for multiple database tables to help debug schema issues and write accurate SQL queries. Use the SUPABASE_LIST_TABLES action first to discover available tables, the fetch their detailed schemas.\",\n  input: SupabaseGetTableSchemasInput,\n  output: SupabaseGetTableSchemasOutput,\n});\n"],"mappings":";;;;AAMA,MAAa,+BAA+BA,IAAAA,EAAE,OAAO;CACnD,aAAaA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,6JAA6J;CAC9L,aAAaA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,CAAC,SAAS,wRAAwR;CAClU,iBAAiBA,IAAAA,EAAE,QAAQ,CAAC,CAAC,QAAQ,IAAI,CAAC,CAAC,SAAS,sDAAsD,CAAC,CAAC,SAAS;CACrH,qBAAqBA,IAAAA,EAAE,QAAQ,CAAC,CAAC,QAAQ,IAAI,CAAC,CAAC,SAAS,qFAAqF,CAAC,CAAC,SAAS;CACxJ,uBAAuBA,IAAAA,EAAE,QAAQ,CAAC,CAAC,QAAQ,IAAI,CAAC,CAAC,SAAS,8DAA8D,CAAC,CAAC,SAAS;AACrI,CAAC,CAAC,CAAC,SAAS,qEAAqE;AACjF,MAAM,mDAAmDA,IAAAA,EAAE,OAAO;CAChE,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,qDAAqD,CAAC,CAAC,SAAS;CAC3F,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,mCAAmC,CAAC,CAAC,SAAS;CAC9E,aAAaA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,CAAC,SAAS,kEAAkE,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;AACpI,CAAC,CAAC,CAAC,YAAY,CAAC,CAAC,SAAS,8CAA8C;AACxE,MAAM,qDAAqDA,IAAAA,EAAE,OAAO;CAClE,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACtC,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC3B,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC5B,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACvC,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,YAAYA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC5C,oBAAoBA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;AACtD,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,2CAA2CA,IAAAA,EAAE,OAAO;CACxD,IAAIA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS;CAC9B,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC1B,OAAOA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC;CACzB,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS;CAClC,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACvC,SAASA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACxC,UAAUA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC/B,WAAWA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CAChC,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACjD,aAAa,mDAAmD,SAAS,CAAC,CAAC,SAAS;CACpF,aAAaA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CAClC,aAAaA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CAClC,cAAcA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CACnC,cAAcA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CACnC,eAAeA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC9C,eAAeA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACpD,gBAAgBA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAChD,kBAAkBA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS;CAC5C,mBAAmBA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACxD,oBAAoBA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACzD,qBAAqBA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACpD,uBAAuBA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;AACxD,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,0CAA0CA,IAAAA,EAAE,OAAO;CACvD,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC1B,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACvC,SAASA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACjD,WAAWA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CAChC,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAChC,YAAYA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CACjC,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;AAC7C,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,2CAA2CA,IAAAA,EAAE,OAAO;CACxD,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC1B,OAAOA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC/C,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACtC,SAASA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC7B,YAAYA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CACjC,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;AAC7C,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,wDAAwDA,IAAAA,EAAE,OAAO;CACrE,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACtC,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC3B,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACvC,SAASA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC;CAC3B,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,YAAYA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC5C,oBAAoBA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;AACtD,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,+CAA+CA,IAAAA,EAAE,OAAO;CAC5D,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC1B,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC1B,SAASA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACjD,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC3C,YAAY,sDAAsD,SAAS,CAAC,CAAC,SAAS;AACxF,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,sDAAsDA,IAAAA,EAAE,OAAO;CACnE,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC1C,cAAcA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAClC,eAAeA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CACnC,eAAeA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CACnC,eAAeA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CACnC,iBAAiBA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;AACvC,CAAC,CAAC,CAAC,YAAY;AACf,MAAM,0CAA0CA,IAAAA,EAAE,OAAO;CACvD,IAAIA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS;CAC9B,MAAMA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC1B,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS;CACjC,OAAOA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACtC,QAAQA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACvC,SAASA,IAAAA,EAAE,MAAM,wCAAwC;CACzD,SAASA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACxC,SAASA,IAAAA,EAAE,MAAM,uCAAuC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC9E,UAAUA,IAAAA,EAAE,MAAM,wCAAwC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAChF,UAAUA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CAC/B,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAC/B,WAAWA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS;CACrC,YAAYA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAOA,IAAAA,EAAE,OAAO,GAAGA,IAAAA,EAAE,QAAQ,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC3E,YAAYA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CACjC,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CAChC,YAAYA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC3C,aAAaA,IAAAA,EAAE,MAAM,4CAA4C,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACvF,aAAaA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC7C,aAAaA,IAAAA,EAAE,QAAQ,CAAC,CAAC,SAAS;CAClC,aAAaA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;CACjC,aAAaA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAClD,cAAcA,IAAAA,EAAE,MAAM,mDAAmD,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CAC/F,cAAcA,IAAAA,EAAE,OAAOA,IAAAA,EAAE,OAAO,GAAGA,IAAAA,EAAE,QAAQ,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACpE,cAAcA,IAAAA,EAAE,MAAMA,IAAAA,EAAE,OAAO,CAAC;CAChC,kBAAkBA,IAAAA,EAAE,OAAO,CAAC,CAAC,SAAS;AACxC,CAAC,CAAC,CAAC,YAAY;AACf,MAAa,gCAAgCA,IAAAA,EAAE,OAAO;CACpD,QAAQA,IAAAA,EAAE,MAAM,gDAAgD,CAAC,CAAC,SAAS,kMAAkM,CAAC,CAAC,SAAS,CAAC,CAAC,SAAS;CACnS,QAAQA,IAAAA,EAAE,MAAM,uCAAuC,CAAC,CAAC,SAAS,4GAA4G;CAC9K,aAAaA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,mDAAmD,CAAC,CAAC,SAAS;CACrG,iBAAiBA,IAAAA,EAAE,OAAO,CAAC,CAAC,IAAI,CAAC,CAAC,SAAS,sDAAsD,CAAC,CAAC,SAAS;AAC9G,CAAC,CAAC,CAAC,YAAY,CAAC,CAAC,SAAS,kFAAkF;AAE5G,MAAa,0BAITC,eAAAA,OAAO,8BAA8B;CACvC,MAAM;CACN,MAAM;CACN,aAAa;CACb,OAAO;CACP,QAAQ;AACV,CAAC"}