db-oauth-mcp

Show whether you're connected and, for each available database connection, which user and engine it uses and when it expires.

Disconnect from all database connections. Revokes the current access token and clears cached credentials. The next tool call will require re-authentication.

List the database connections available in the current session. Returns the name (pass to query_database / list_schema via the connection argument), engine type (mariadb or mssql), and the databases each connection grants access to. Calling this will trigger authentication if not yet connected.

List tables or describe a specific table's columns for a given connection. Pass connection with the name of the target (omit if only one connection exists). Call with no table argument to see all tables, or with table set to 'schema.table' (MariaDB uses database.table; MSSQL uses schema.table within the connection's initial catalog) to describe its columns.

Execute a read-only SQL query against one of the configured database connections. Pass connection with the name of the target (omit if only one connection exists — use list_connections to see the names and which engine each uses). Only read statements are allowed (SELECT/SHOW/DESCRIBE/EXPLAIN/WITH on MariaDB; SELECT/WITH and a small allowlist of sp_help / sp_columns / sp_tables procs on MSSQL). Results are capped at a configurable row limit (default 1000). Use list_schema first if you don't know the table structure.