The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { afterEach, beforeEach, describe, expect, it, vi } from 'vitest'
import { getDebuggingOperations, getDevelopmentOperations } from './mcp'
vi.mock('./settings', () => ({
getProjectSettings: vi.fn(),
}))
vi.mock('./generate-types', () => ({
generateTypescriptTypes: vi.fn(),
}))
vi.mock('./logs', () => ({
retrieveAnalyticsData: vi.fn(),
}))
vi.mock('./lints', () => ({
getLints: vi.fn(),
}))
describe('api/self-hosted/mcp', () => {
describe('getDevelopmentOperations.getPublishableKeys', () => {
let getProjectSettingsMock: ReturnType<typeof vi.fn>
beforeEach(async () => {
vi.unstubAllEnvs()
const settings = await import('./settings')
getProjectSettingsMock = vi.mocked(settings.getProjectSettings)
})
afterEach(() => {
vi.unstubAllEnvs()
})
it('returns a publishable-typed key from SUPABASE_PUBLISHABLE_KEY when set', async () => {
vi.stubEnv('SUPABASE_PUBLISHABLE_KEY', 'sb_publishable_abc')
const ops = getDevelopmentOperations({})
const keys = await ops.getPublishableKeys('default')
expect(keys).toEqual([
{
api_key: 'sb_publishable_abc',
name: 'publishable',
type: 'publishable',
},
])
// When the env var is set we should short-circuit and never consult project settings.
expect(getProjectSettingsMock).not.toHaveBeenCalled()
})
it('falls back to the anon key from project settings with type "legacy" when env var is unset', async () => {
vi.stubEnv('SUPABASE_PUBLISHABLE_KEY', '')
getProjectSettingsMock.mockReturnValue({
service_api_keys: [
{ api_key: 'service-key-value', name: 'service_role key', tags: 'service_role' },
{ api_key: 'anon-key-value', name: 'anon key', tags: 'anon' },
],
})
const ops = getDevelopmentOperations({})
const keys = await ops.getPublishableKeys('default')
expect(keys).toEqual([
{
api_key: 'anon-key-value',
name: 'anon key',
type: 'legacy',
},
])
})
it('throws when env var is unset and the anon key is missing from project settings', async () => {
vi.stubEnv('SUPABASE_PUBLISHABLE_KEY', '')
getProjectSettingsMock.mockReturnValue({
service_api_keys: [
{ api_key: 'service-key-value', name: 'service_role key', tags: 'service_role' },
],
})
const ops = getDevelopmentOperations({})
await expect(ops.getPublishableKeys('default')).rejects.toThrow(
'Anon key not found in project settings'
)
})
})
describe('getDebuggingOperations', () => {
let retrieveAnalyticsDataMock: ReturnType<typeof vi.fn>
beforeEach(async () => {
vi.unstubAllEnvs()
const logs = await import('./logs')
retrieveAnalyticsDataMock = vi.mocked(logs.retrieveAnalyticsData)
})
afterEach(() => {
vi.unstubAllEnvs()
})
it('getLogs is not supported on self-hosted (query_logs supersedes it)', async () => {
const ops = getDebuggingOperations({})
// `get_logs` is hidden by the MCP server whenever `queryLogs` is present,
// so this method is unreachable over MCP and throws defensively.
await expect(ops.getLogs('default', { service: 'api' })).rejects.toThrow(
'get_logs is not supported on self-hosted'
)
expect(retrieveAnalyticsDataMock).not.toHaveBeenCalled()
})
it('queryLogs throws when logs are disabled (self-hosted default)', async () => {
vi.stubEnv('ENABLED_FEATURES_LOGS_ALL', 'false')
const ops = getDebuggingOperations({})
await expect(ops.queryLogs!('default', { sql: 'select 1' })).rejects.toThrow(
'Logs are disabled on this instance'
)
expect(retrieveAnalyticsDataMock).not.toHaveBeenCalled()
})
it('queryLogs passes the model-provided SQL straight through when logs are enabled', async () => {
vi.stubEnv('ENABLED_FEATURES_LOGS_ALL', 'true')
retrieveAnalyticsDataMock.mockResolvedValue({ data: ['log entry'], error: null })
const ops = getDebuggingOperations({})
await ops.queryLogs!('default', { sql: 'select * from edge_logs' })
expect(retrieveAnalyticsDataMock).toHaveBeenCalledWith(
expect.objectContaining({
params: expect.objectContaining({ sql: 'select * from edge_logs' }),
})
)
})
})
})