Operate with confidence

Supabase announced new agent-facing tools at Supabase Select, including a query_logs MCP tool that gives coding agents raw SQL access to project logs, expanded Advisor health checks across Data API, Auth, Storage and Edge Functions, and Notebooks for saved queries plus markdown notes. The company also added Database Connections monitoring, enabled by default for every project including self-hosted, and Enterprise-Managed Auth for its MCP server starting with Okta using short-lived tokens bound to members. Notebooks ship in the new Explorer SQL editor rolling out to every project through October 12, with Notebook CLI tools in the beta CLI.

Today at Supabase Select, we announced new tools that let your coding agent find production problems, test fixes, and report back, and new controls that set what the agent can access and when it stops to ask you first. Diagnosing a production problem today means reading logs, usage charts, and database reports separately and correlating them yourself. Your agent could already read that data, but it had no procedure for investigating and no safe place to test a fix. For an agent to confidently operate a project: - It needs data data to observe - It needs knowledge knowledge on what to look for in that data - It needs autonomy autonomy to test and validate fixes in its own environment - It needs permission permissions to do only what is required Data data query logs query logs Previously your agents were limited in what logs they could access via our MCP. We’ve introduced a new MCP tool that gives your agents raw access to your project logs via SQL, which enables more in-depth and precise investigations. More advisor checks more-advisor-checks Programmatic checks can catch obvious issues and provide signal for an agent to investigate further. Advisor previously focused on security and performance checks. We’ve now extended it to health. Advisor will signal when error rates go beyond what is considered normal across Data API, Auth, Storage, and Edge Functions. Checks run on demand from the dashboard or the Management API, and results show up under a new Health tab on the Advisors page. Database Connections database-connections See which sessions hold connections, which queries run long, which are idle in a transaction, which are blocked, and who holds the lock. You can cancel a query or terminate its connection from there. It's on by default for every project, including self-hosted. Introducing Notebooks introducing-notebooks A notebook is a file in your supabase folder that combines saved database or log queries with markdown notes. Run Notebooks yourself or get your agents to run them as part of their ongoing observations. You can create notebooks directly in the dashboard via the Assistant, then pull them down locally as files with supabase notebooks pull if needed. You can also create notebooks locally including with your own agent and push them with supabase notebooks push to make them accessible in the dashboard. Notebooks can be found in the new Explorer, an evolution of the SQL editor, which is rolling out to every project through October 12. Once it reaches your project, you can turn it on under Feature Previews in the dashboard. Notebook CLI tools are available in the beta version of our CLI. Knowledge knowledge Updated Skills updated-skills Supabase skills now point to a living document of common health, security, performance, and resource signals your agent should watch for and how to monitor those signals. 10npm install supabase --save-dev 10npx plugins add supabase-community/supabase-plugin Autonomy autonomy Agents operate best in code. Today at Supabase Select we announced several improvements to how Supabase projects are expressed as code, and how that code can run in more environments. This is an important upgrade for the observing → detection → resolving loop: it lets agents test and validate proposed fixes in their own environment before opening a PR. That environment may not be your local machine. Read more about pg-delta and upgrades to the local runtime in the Build post https://supabase.com/blog/select-2026-build-anything . Permissions permissions Give your agent only the access it needs to do its job, and get alerted when it attempts a riskier action. Enterprise-Managed Auth for MCP enterprise-managed-auth-for-mcp Your company decides who can connect to the Supabase MCP server through its identity provider, starting with Okta. Each token is short-lived and bound to the member who signed in. To cut off access, remove the app from Authorized Apps, or remove the member. This is generally available. Scoped Personal Access Tokens scoped-personal-access-tokens Limit a token to the organizations, projects, and permissions you choose. Start with a read-only token. It's generally available and is now the default for new tokens created in the dashboard. MCP Elicitations mcp-elicitations Before the agent creates a paid project or branch, the Supabase MCP server asks you to confirm the resource, rate, and billing interval in your agent client, then waits for your answer. It also asks for confirmation before running SQL that could delete data. This helps prevent unwanted charges and data loss, but it’s not a guarantee. Your agent client must support elicitations for the prompt to appear. Supabase Pipelines supabase-pipelines Pipelines stream your Postgres data to analytical destinations in near real time, so heavy analytics queries don’t impact primary Postgres. Create a pipeline in the dashboard, choose the destination, and select the tables to replicate. The initial sync starts, and schema changes are detected and applied to the destination automatically. The dashboard shows each pipeline's health and the status of every replicated table. Pipelines are in public alpha on the Pro, Team, and Enterprise plans, with BigQuery, ClickHouse, DuckLake, and Snowflake as destinations. Getting started getting-started Setting up an agent that autonomously observes your project, detects issues, and proposes fixes can be daunting, but it’s really only a prompt away with your favorite agent harness. We’ve created a few prompts and suggested schedules to set your agent up for success. - Health https://supabase.com/docs/guides/observability/automate-with-agents/health - Security https://supabase.com/docs/guides/observability/automate-with-agents/security - Performance https://supabase.com/docs/guides/observability/automate-with-agents/performance - Resources https://supabase.com/docs/guides/observability/automate-with-agents/usage - Supabase Pipelines: on a paid plan, open Database, then Pipelines in the Dashboard, add a BigQuery, ClickHouse, DuckLake, or Snowflake destination, and pick your tables. Docs https://supabase.com/docs/guides/database/replication/pipelines .