Schema | duckdb-mcp

duckdb-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`SCHEMA`	No	Default schema. Corresponds to the --schema option. Default: 'main'.	main
`INIT_SQL`	No	Path to a SQL file executed once on startup. Corresponds to the --init-sql option.
`READ_ONLY`	No	Set to 'true' to open the database read-only, 'false' for read-write. Corresponds to the --read-only flag. Default: 'false'.	false
`DATABASE_PATH`	No	Path to the DuckDB database. Use ':memory:' for an in-memory database. Corresponds to the --db/--database option. Default: ':memory:'.	:memory:

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
queryB	Execute a SQL SELECT query and return the results.
executeA	Execute a SQL statement (INSERT, UPDATE, DELETE, CREATE, ...) without returning rows.
read_csvC	Read a CSV file into a table.
read_parquetC	Read a Parquet file into a table.
list_catalogsA	List all catalogs.
list_databasesA	List all databases.
list_schemasA	List all schemas.
list_tablesA	List all tables in the current schema.
list_columnsB	List the columns of a table.
list_extensionsA	List loaded extensions.
list_environmentsA	List environment variables as key: value, with values masked (**** / empty).
check_versionA	Check the DuckDB version.

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/wuqunfei/duckdb-mcp-mini'

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