1export const supabasePostgresIntegrationSpec = defineIntegration({
2	meta: {
3		key: 'database.supabase',
4		version: '1.0.0',
5		category: 'database',
6		title: 'Supabase Postgres',
7		description:
8			'Supabase Postgres integration for SQL query execution and transactional workloads.',
9		domain: 'infrastructure',
10		owners: ['platform.infrastructure'],
11		tags: ['database', 'postgres', 'supabase'],
12		stability: StabilityEnum.Beta,
13	},
14	supportedModes: ['managed', 'byok'],
15	transports: [
16		{ type: 'rest' },
17		{ type: 'sdk', packageName: '@supabase/supabase-js' },
18	],
19	preferredTransport: 'rest',
20	supportedAuthMethods: [{ type: 'api-key' }, { type: 'basic' }],
21	capabilities: {
22		provides: [{ key: 'database.sql', version: '1.0.0' }],
23	},
24	configSchema: {
25		schema: {
26			type: 'object',
27			properties: {
28				maxConnections: {
29					type: 'number',
30					description:
31						'Optional connection pool size when opening a Postgres client to Supabase.',
32				},
33				sslMode: {
34					type: 'string',
35					enum: ['require', 'allow', 'prefer'],
36					description: 'TLS mode used by the Postgres client.',
37				},
38			},
39		},
40		example: {
41			maxConnections: 10,
42			sslMode: 'require',
43		},
44	},
45	secretSchema: {
46		schema: {
47			type: 'object',
48			required: ['databaseUrl'],
49			properties: {
50				databaseUrl: {
51					type: 'string',
52					description:
53						'Supabase Postgres connection string (transaction or session pooler endpoint).',
54				},
55			},
56		},
57		example: {
58			databaseUrl:
59				'postgresql://postgres.[project-ref]:password@aws-0-region.pooler.supabase.com:6543/postgres',
60		},
61	},
62	healthCheck: {
63		method: 'ping',
64		timeoutMs: 5000,
65	},
66	docsUrl: 'https://supabase.com/docs/guides/database/connecting-to-postgres',
67	byokSetup: {
68		setupInstructions:
69			'Create or reuse a Supabase project and provide a Postgres connection string with permissions aligned to your workload.',
70		keyRotationSupported: true,
71		quotaTrackingSupported: false,
72	},
73});