v0.4 - Query MCP Release 🚀

v0.4 - Query MCP

To say that I am excited is to say nothing. This release might not have any grand new features (besides a couple of annoying bugs squashed and improved startup/shutdown routine), but it's epic.

Query MCP is evolving and it's now in Early Access at thequery.dev.

Lot's more coming soon - stay tuned!

What's Changed

• feat: introduce api client <> server separation by @alexander-zuev in #62

Full Changelog: v0.3.12...v0.4

v0.4-beta-1 - Query MCP

Pre-release version of Query MCP. Stand by for the v0.4 drop.

What's Changed

• feat: introduce api client <> server separation by @alexander-zuev in #62

Full Changelog: v0.3.12...v0.4-beta-1

v0.3.12 - Logs & Analytics: Log retrieval tool 🤓

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 #56

Full Changelog: v0.3.11...v0.3.12

v0.3.11: Fix non-existent migration schema bug 🐞

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 #49
• fix(migrations): fix issue with cold start of migration schema by @alexander-zuev in #51

Full Changelog: v0.3.10...v0.3.11

v0.3.10 - Improved migration name generation ✍️

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 #48

Full Changelog: v0.3.9...v0.3.10

v0.3.9 - Small bugfix release 🐞

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 #43

Full Changelog: v0.3.8...v0.3.9

v0.3.8 - Architecture overhaul and new safety mode 👷‍♂️

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 #41
• fix(tests): error in duplicate migration names by @alexander-zuev in #42

Full Changelog: v0.3.7...v0.3.8

v0.3.7 - Local usage of Auth Admin Python SDK 🔐

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)

What's Changed 📋

• docs: add contributing.md by @alexander-zuev in #23
• chore: add Docker and environment configuration files by @alexander-zuev in #24
• feat(sdk): enable python sdk usage locally by @alexander-zuev in #25

Full Changelog: v0.3.6...v0.3.7

v0.3.6 - Auth Admin SDK integration 🔐

What's Changed

• Feat/auth sdk by @alexander-zuev in #17

Full Changelog: v0.3.5...v0.3.6

v0.3.5 - Fix get_tables and update docs 📚

What's Changed

• Fix/foreign tables by @alexander-zuev in #15
• Update docs to describe mcp.json config
• Enhance test suite to cover all tools of the MCP server

Full Changelog: v0.3.4...v0.3.5