Schema | secure-mcp-database-crud

secure-mcp-database-crud

Describes the environment variables required to run the server.

Name	Required	Description	Default
`SQLITE_PATH`	No	Path to SQLite database file	data/tasks.db
`MYSQL_POOL_SIZE`	No	Number of connections in each MySQL connection pool	5
`DATABASE_BACKEND`	No	Database backend: sqlite or mysql	sqlite
`DB_TIMEOUT_SECONDS`	No	Database connection and lock timeout in seconds	5
`CONFIRMATION_SIGNING_KEY`	Yes	HMAC signing key for deletion tokens (32+ characters)
`CONFIRMATION_TTL_SECONDS`	No	Time-to-live for deletion confirmation in seconds	120

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_tasksB	List tasks with bounded pagination and allowlisted sorting.
get_taskA	Get one task by its positive integer ID.
prepare_delete_taskA	Return the exact delete target and a short-lived confirmation token.
create_taskA	Create one validated task and its audit event atomically.
update_taskA	Update only allowlisted task fields, optionally checking the observed version.
confirm_delete_taskA	Delete the confirmed task after validating its signed, single-use token.

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/yunosuke-github/secure-mcp-database-crud'

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