delete_expense
Remove an expense entry from the Expense Tracker database by specifying its unique identifier to maintain accurate financial records.
Instructions
Delete an expense from the database.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"id": "<id>"
},
"name": "delete_expense"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes |
Implementation Reference
- main.py:135-146 (handler)The handler function 'delete_expense' is registered as an MCP tool and performs a SQL DELETE operation on the expenses table.
@mcp.tool() def delete_expense(id): """Delete an expense from the database.""" try: with sqlite3.connect(DB_PATH) as conn: cursor = conn.cursor() cursor.execute("DELETE FROM expenses WHERE id = ?", (id,)) if cursor.rowcount == 0: return {"status": "error", "error": "No expense with that id"} return {"status": "ok"} except Exception as e: return {"status": "error", "error": str(e)}