Schema | biz-db-mcp

biz-db-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`BIZDB_ORG_ID`	No	Organization ID used for export identity.
`DBPM_APP_KEY`	No	DBPM private key passed to the bridge process via environment variable.
`BIZDB_USER_ID`	No	User ID used for export identity.
`BIZDB_MYSQL_DSN`	No	MySQL DSN for single database configuration (e.g., mysql://user:password@host:3306/database).
`BIZDB_SESSION_ID`	No	Session ID used for export identity.
`BIZDB_DBPM_APP_IP`	No	DBPM application IP address.
`BIZDB_DBPM_APP_KEY`	No	DBPM application key.
`BIZDB_DBPM_COMMAND`	No	Command to execute the DBPM bridge.
`BIZDB_DBPM_ENABLED`	No	Whether DBPM (password management system) is enabled. If 'true', the following DBPM_* variables are required.	false
`BIZDB_DBPM_SERVERS`	No	Comma-separated list of DBPM servers.
`BIZDB_DBPM_APP_NAME`	No	DBPM application name.
`BIZDB_WRITE_ENABLED`	No	Whether write operations are enabled. Set to 'true' to allow DML.	false
`BIZDB_DATABASES_JSON`	No	JSON configuration for multiple databases. Can be a mapping or a {'connections': [...]} array.
`BIZDB_DEFAULT_DATABASE`	No	Database ID to use as the default database.
`BIZDB_SANDBOX_BASE_URL`	No	Base URL of the Sandbox for dataset export.
`BIZDB_SANDBOX_API_TOKEN`	No	API token for Sandbox dataset export.
`BIZDB_WRITE_REQUIRE_WHERE`	No	Whether WHERE clause is required for UPDATE/DELETE operations. Set to 'false' to disable.	true
`BIZDB_WRITE_MAX_AFFECTED_ROWS`	No	Maximum number of affected rows allowed for write operations.

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
list_databasesA	List configured database ids without exposing DSNs or credentials.
describe_tableB	Return column metadata for a table in one configured database.
queryA	Run a bounded read-only SELECT. Use export for bulk pulls.
executeC	Execute one guarded DML statement when writes are explicitly enabled.
exportA	Stream a SELECT to Parquet and register it as a Sandbox Dataset. The destination session and acting identity come from process-level environment variables, never from model-supplied tool arguments.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/nusduck/biz-db-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server