Supabase-mcp-server

Key changes
- Introducing the first tool of a new tool "Logs & Analytics" suite:
- `retrieve_logs` tool allows users to easily retrieve logs from any log collection in Supabase, such as Auth, Postgres, PostgREST, Edge functions and many others. This will greatly aid in debugging and working with Supabase instance from the IDE / MCP client.
- updated README and smithery.yaml to clarify `SUPABASE_DB_REGION` is a required variable (no breaking changes, but this will be enforced in future versions)
- improved error handling of "Tenant not found", which is often caused by the mismatch between the region MCP server connects to
- introduced log rotation to avoid log overflow


Commits
* feat(logs): introduce retrieve_logs tool by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/56


**Full Changelog**: https://github.com/alexander-zuev/supabase-mcp-server/compare/v0.3.11...v0.3.12

Key changes
This is primarily a bug fix release:
- fixed a bug which prevented postgresql queries from being executed due to non-existent migration schemas (44 )
- slightly updated smithery.yaml config

Commits
* fix: attempt 2 to fix smithery deploy by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/49
* fix(migrations): fix issue with cold start of migration schema by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/51


**Full Changelog**: https://github.com/alexander-zuev/supabase-mcp-server/compare/v0.3.10...v0.3.11

Key changes
- Improved migration name generation to ensure consistency - timestamp_verb_noun_details.sql. MCP clients can now also provide migration names.
- Improved `get_migrations` tool to ensure reliability of tool calls in cases where a database has lots of migrations
- Added checks to validate personal access token and service role key before API calls
- Added support for multiple MCP clients (Cursor, Windsurf, Claude Desktop, Cline)

Commits
* feat(database): enhance migration management and query validation by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/48


**Full Changelog**: https://github.com/alexander-zuev/supabase-mcp-server/compare/v0.3.9...v0.3.10

What's inside
- Fixed a bug with api_spec retrieval tool

What's Changed
* fix(api): fix a bug with api_spec retrieval by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/43


**Full Changelog**: https://github.com/alexander-zuev/supabase-mcp-server/compare/v0.3.8...v0.3.9

Added
- SQL query validation using PostgreSQL's parser (pglast v7.3+)
- Automatic migration script generation for schema changes
- Universal safety system with standardized risk levels (Low/Medium/High/Extreme)
- Switched to asyncpg v0.30.0+ from psycopg2
- Enhanced API spec tool with multiple query modes and risk assessment
- Connection retry logic for database and API operations
- Code coverage with pytest-cov
- SQL linting with SQLFluff
- Added pyyaml v6.0.2+ for configuration

Changed
- Refactored to use dependency injection pattern
- Standardized service initialization to synchronous pattern
- Improved SQL safety categorization:
- `safe`: Read-only operations (always allowed)
- `write`: Data modification (requires unsafe mode)
- `destructive`: Schema changes (requires unsafe mode + confirmation)
- Updated Ruff to v0.9.9
- Added asyncpg-stubs and pytest-mock for testing

Commits in this release
* feat: sql syntax validation, new safety mode, automatic migration, new db client, improved tools by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/41
* fix(tests): error in duplicate migration names by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/42


**Full Changelog**: https://github.com/alexander-zuev/supabase-mcp-server/compare/v0.3.7...v0.3.8

Description 📚
This is a smaller update including 3 changes:
- fix typos and missing env vars in Readme and .env.example
- deployed to smithery.ai
- a small (but neat) improvement to allow Auth Admin SDK tools to be used with local Supabase instances (Raised by [dewinterjack](https://github.com/dewinterjack))

What's Changed 📋
* docs: add contributing.md by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/23
* chore: add Docker and environment configuration files by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/24
* feat(sdk): enable python sdk usage locally by alexander-zuev in https://github.com/alexander-zuev/supabase-mcp-server/pull/25


**Full Changelog**: https://github.com/alexander-zuev/supabase-mcp-server/compare/v0.3.6...v0.3.7