Schema | mcp-commands

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MCP_PORT`	No	Port used for SSE mode.	8432
`DATABASE_URL`	No	PostgreSQL DSN for the database connection.	postgresql://mcp_commands:mcp_commands@localhost:5432/mcp_commands
`MCP_TRANSPORT`	No	Transport mode, either 'stdio' or 'sse'.	stdio

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
log_command_tool	`Log one AI command usage. Args: command: The command name, e.g. '/commit', '/recap', 'deep-research' category: Optional group, e.g. 'git', 'research', 'oracle', 'session' context: Optional free-text note about where/why it was used`
get_history_tool	`Get recent command-usage history. Args: limit: Max rows to return (default 20) command: Filter by command name (partial match) category: Filter by category (exact match)`
get_stats_tool	`Get command usage statistics. Args: top_n: How many top items to show per category (default 10) Returns JSON with: - total usage count - top commands ranked by usage - top categories ranked by usage - daily counts for the last 7 days`
search_commands_tool	`Search command history by keyword. Searches across command name, category, and context fields. Args: query: Search keyword limit: Max results (default 20)`
delete_command_tool	`Delete a command-usage record by its id. Args: row_id: The id field from history records`

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

mcp-commands