Highlights
Smarter MCP agents out of the box
The MCP server now ships server instructions that every connected client receives automatically. AI agents are steered toward the 118 dedicated tools (across 20 domains) instead of falling back to raw execute_sql for operations that already have purpose-built alternatives. If you have ever seen an agent run SELECT * FROM sys.tables instead of calling list_tables, this release fixes that. (#986, #993)
CLI positional arguments just work
Commands with an optional leading positional (like WAREHOUSE) followed by required positionals no longer break when you rely on the configured default. Previously, fdw schemas delete my_schema would fail with "Missing argument 'NAME'" because Click filled the optional slot first. This is fixed for all 61 affected commands across 15 groups - both short-form and full-form invocations work as expected. (#987)
httpx compatibility guard
The httpx dependency is now capped at <1.0 to prevent --prerelease allow installs from pulling httpx 1.0 dev releases, which removed TransportError and broke the MCP transport layer. A pre-publish smoke test now catches this class of resolution-time breakage before it reaches PyPI. (#997)
Other improvements
- CI:
server.jsonversion is now kept in sync with stable release tags automatically (#977) - CI: lockfile consistency is asserted across all workflows, preventing drift between
pyproject.tomlanduv.lock(#989, #991) - Tests: added end-to-end journey smoke test for config defaults (#983)
- Tests: sql-pools integration tests now ensure a warehouse exists before running (#996)
Dependencies
- Bump
tyfrom 0.0.55 to 0.0.59 (#978, #998) - Bump
astral-sh/setup-uvfrom 8.2.0 to 8.3.2 (#980, #999) - Bump major dependency group (3 updates) (#979)
Full changelog
- chore(deps-dev): bump ty from 0.0.56 to 0.0.59 in the patch-and-minor group (#998)
- chore(deps): bump astral-sh/setup-uv from 8.3.0 to 8.3.2 in the patch-and-minor group (#999)
- fix(deps): cap httpx below 1.0 so the pre-release build installs (#997)
- fix(test): ensure a warehouse exists before sql-pools integration tests (#996)
- feat(mcp): name the remaining tool domains in the server instructions (#993)
- fix(ci): assert lockfile consistency in the remaining workflows (#991)
- test(integration): add end-to-end journey smoke test for config defaults (#983)
- fix(ci): regenerate uv.lock and gate lockfile drift (#989)
- fix(cli): right-align positional args so optional ITEM can be omitted (#987)
- feat(mcp): add server instructions steering agents to dedicated tools (#986)
- chore(deps): bump the major group with 3 updates (#979)
- chore(deps): bump astral-sh/setup-uv from 8.2.0 to 8.3.0 in the patch-and-minor group (#980)
- chore(deps-dev): bump ty from 0.0.55 to 0.0.56 in the patch-and-minor group (#978)
- ci(release): keep server.json version in sync on stable tags (#977)