v0.4.0
Added
- OAuth for the Streamable HTTP transport. With
GIZMOSQL_MCP_OAUTH_ISSUERand
GIZMOSQL_MCP_PUBLIC_URLset, the server acts as an OAuth 2.1 resource server
for any OpenID Connect provider that issues JWT access tokens (Microsoft Entra
ID, Okta, Auth0, Keycloak, Cognito, Clerk): it discovers the provider's JWKS,
verifies issuer, audience, signature and expiry on every request, serves the
RFC 9728 protected-resource metadata at/.well-known/oauth-protected-resource
(and the/mcp-suffixed form), and answers 401 with theWWW-Authenticate
challenge Claude.ai uses to start the sign-in flow. Optional
GIZMOSQL_MCP_OAUTH_AUTHORIZED_EMAILSrestricts callers to an email allowlist
(403),GIZMOSQL_MCP_OAUTH_AUDIENCEaccepts several audiences, and
GIZMOSQL_MCP_OAUTH_JWKS_URIskips discovery. The caller's token is never
forwarded: GizmoSQL is reached with the configured service credentials. - Per-user sessions over HTTP. Each authenticated user gets their own
GizmoSQL connections, current connection and search path, souse_schema,
USEanduse_connectionno longer leak between people sharing one
server. Sessions close afterGIZMOSQL_MCP_SESSION_IDLE_SECONDS(default
1800) without a request or whenGIZMOSQL_MCP_MAX_SESSIONS(default 200)
is reached, least recently used first.server_inforeports
session_scope,session_startedandsession_idle_timeout_seconds. - Every JSON-RPC request over HTTP is logged with the authenticated caller and
the tool or resource it touched, andserver_inforeportsauthenticated_user. - A container image for the HTTP transport (
ghcr.io/gizmodata/gizmosql-mcp,
linux/amd64 and linux/arm64) and a Helm chart
(oci://ghcr.io/gizmodata/charts/gizmosql-mcp), both published by the release
workflow with versions locked to the npm package.
Changed
GIZMOSQL_MCP_BEARER_TOKENand OAuth are mutually exclusive; configuring both
is a startup error. The 401 for a static token now carries a JSON body.login_ssois only registered on the stdio transport; over HTTP it would
open a browser on the server.
Container image: ghcr.io/gizmodata/gizmosql-mcp:0.4.0 (linux/amd64, linux/arm64)
Helm chart: oci://ghcr.io/gizmodata/charts/gizmosql-mcp --version 0.4.0