mirror of
https://github.com/supabase/supabase.git
synced 2026-09-06 09:59:03 +08:00
> [!IMPORTANT] > > Only merge this when (https://github.com/supabase/platform/pull/36804) is merged, as the AI assistant will not have access to the `query_logs` tool for the remote MCP server ## I have read the [CONTRIBUTING.md](https://github.com/supabase/supabase/blob/master/CONTRIBUTING.md) file. YES ## What kind of change does this PR introduce? Feature (self-hosted / CLI Studio MCP server). ## What is the current behavior? Self-hosted `getDebuggingOperations` (`apps/studio/lib/api/self-hosted/mcp.ts`) implements only `getLogs`, so the MCP `debugging` group exposes `get_logs` — a fixed per-service log dump built by `getLogQuery`. Logs are served by Logflare, which speaks BigQuery SQL. ## What is the new behavior? Bumps `@supabase/mcp-server-supabase` to `^0.10.0` (adds `query_logs` + `logsDialect`, and hides `get_logs` wherever a platform declares `queryLogs`) and moves logs over to it. - **Self-hosted `query_logs`:** declares `logsDialect: 'bigquery'` and implements `queryLogs`, passing the model's SQL straight through to the same Logflare `logs.all` endpoint (arbitrary `sql` param) — no new endpoint, no dialect translation. - **Drops `get_logs` from self-hosted:** `getLogs` throws (the server hides it once `queryLogs` exists) and the per-service `getLogQuery` builder is deleted; the model now writes its own BigQuery SQL, guided by the dialect schema hint. - **Honors no-logs mode:** `query_logs` throws when `logs:all` is disabled — the self-hosted default, enabled via the `docker-compose.logs.yml` override. - **Assistant:** switches the dashboard assistant from `get_logs` to `query_logs` (allowlist, drift guard, prompt, mocks, evals). Refs AI-1046 <!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit * **New Features** * AI debugging can query recent project logs using read-only SQL. * Log queries support optional time-range filters, filtering, aggregation, and joins. * Self-hosted debugging checks whether logging is enabled before running queries. * **Bug Fixes** * Updated debugging workflows and validation to consistently use the new log-query capability. * Removed reliance on legacy service-specific log filtering and query behavior. * **Documentation** * Updated MCP debugging tool guidance to describe SQL-based log queries. * **Tests** * Expanded coverage for enabled, disabled, and unsupported logging scenarios. <!-- end of auto-generated comment: release notes by coderabbit.ai --> --------- Co-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
72 lines
1.8 KiB
TypeScript
72 lines
1.8 KiB
TypeScript
import assert from 'node:assert'
|
|
|
|
import { WrappedResult } from './types'
|
|
import { assertSelfHosted } from './util'
|
|
import { PROJECT_ANALYTICS_URL } from '@/lib/constants/api'
|
|
|
|
export type RetrieveAnalyticsDataOptions = {
|
|
name: string
|
|
projectRef: string
|
|
params: Record<string, string | undefined>
|
|
}
|
|
|
|
export type AnalyticsResult = {
|
|
result?: any[]
|
|
error?: {
|
|
message: string
|
|
}
|
|
[key: string]: any
|
|
}
|
|
|
|
/**
|
|
* Retrieves analytics data from Logflare.
|
|
*
|
|
* _Only call this from server-side self-hosted code._
|
|
*/
|
|
export async function retrieveAnalyticsData({
|
|
name,
|
|
projectRef,
|
|
params,
|
|
}: RetrieveAnalyticsDataOptions): Promise<WrappedResult<AnalyticsResult>> {
|
|
assertSelfHosted()
|
|
assert(PROJECT_ANALYTICS_URL, 'PROJECT_ANALYTICS_URL is required')
|
|
assert(process.env.LOGFLARE_PRIVATE_ACCESS_TOKEN, 'LOGFLARE_PRIVATE_ACCESS_TOKEN is required')
|
|
|
|
const url = new URL(`${PROJECT_ANALYTICS_URL}endpoints/query/${name}`)
|
|
url.searchParams.set('project', projectRef)
|
|
|
|
// Add all other params
|
|
Object.entries(params).forEach(([key, value]) => {
|
|
if (value !== undefined) {
|
|
url.searchParams.set(key, value)
|
|
}
|
|
})
|
|
|
|
try {
|
|
const response = await fetch(url, {
|
|
method: 'GET',
|
|
headers: {
|
|
'x-api-key': process.env.LOGFLARE_PRIVATE_ACCESS_TOKEN,
|
|
'Content-Type': 'application/json',
|
|
Accept: 'application/json',
|
|
},
|
|
})
|
|
|
|
const result = await response.json()
|
|
|
|
if (!response.ok) {
|
|
const error = new Error(
|
|
result?.error?.message ?? `Failed to retrieve analytics data: ${response.statusText}`
|
|
)
|
|
return { data: undefined, error }
|
|
}
|
|
|
|
return { data: result, error: undefined }
|
|
} catch (error) {
|
|
if (error instanceof Error) {
|
|
return { data: undefined, error }
|
|
}
|
|
throw error
|
|
}
|
|
}
|