# Observe the data

Query logs, metrics, database diagnostics, and advisors. Each source page lists Studio, MCP, the API, and the CLI.

This guide lists the project data you can query. Each source page lists where to read that source. To pick up a signal from this data, see [Detecting](https://supabase.com/docs/guides/observability/detecting).

## Logs

Request, database, Auth, Storage, Realtime, and function events in ClickHouse.

Query them with SQL in [Query and filter logs](https://supabase.com/docs/guides/observability/advanced-log-filtering) from the [Logs Explorer](https://supabase.com/dashboard/project/_/logs/explorer), MCP `query_logs`, or the [Management API](https://supabase.com/docs/reference/api/v1-get-project-logs). Filter events without SQL in [Logs](https://supabase.com/docs/guides/observability/logs). See the [Logs field reference](https://supabase.com/docs/guides/observability/log-field-reference) for sources and fields.

The CLI does not query ClickHouse logs. Call the Management API from a script, or [inspect the database](https://supabase.com/docs/guides/observability/inspect) for Postgres diagnostics.

## Metrics \[#metrics-api]

Prometheus-compatible CPU, IO, WAL, connections, and query stats. Scrape the [Metrics API](https://supabase.com/docs/guides/observability/metrics) for custom dashboards, alerting, or retention beyond Studio. Chart a subset of the same window in [Reports](https://supabase.com/docs/guides/observability/reports).

## Database

Live Postgres statistics such as bloat, cache hit rate, blocking sessions, index usage, and slow queries. Run the same checks from the [SQL Editor](https://supabase.com/dashboard/project/_/sql), MCP `execute_sql`, or `supabase inspect db`. See [Inspect the database](https://supabase.com/docs/guides/observability/inspect).

## Advisors

Deterministic security and performance findings. Pull them from Studio, MCP `get_advisors`, [`supabase db advisors`](https://supabase.com/docs/reference/cli/usage#supabase-db-advisors), or the Management API. See [Advisors](https://supabase.com/docs/guides/observability/advisors).

## Reports

Studio dashboards for API, Auth, Storage, Realtime, and database signals. Use them to pick a time window or resource, then follow [Detecting](https://supabase.com/docs/guides/observability/detecting). See [Reports](https://supabase.com/docs/guides/observability/reports).