Todo

Provides a Postgres TCP-based MCP server to manage todos via TLS-authenticated connections.

javascript

GitHub Stars

javascript

Language

6 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "maxabrahamsson-todo-mcp-db4app": {
      "command": "npx",
      "args": [
        "-y",
        "db4app-todo-mcp-server@latest"
      ],
      "env": {
        "MCP_SCHEMA": "todo_mcp",
        "MCP_AUTH_TOKEN": "YOUR_AUTH_TOKEN",
        "MCP_POSTGRES_URL": "postgres://postgres:YOUR_AUTH_TOKEN@YOUR_CONNECTION_ID.pg.db4.app",
        "MCP_CONNECTION_ID": "your_connection_id"
      }
    }
  }
}

You can run the db4app todo MCP server to let large language models manage a browser-based todo list using a Postgres TCP connection. It uses TLS and password authentication to securely connect your client to the browser’s data store, enabling seamless create, update, and query operations via the Model Context Protocol.

How to use

Set up and connect your MCP client to the server to start managing todos. You’ll connect through a local, plaintext-free pathway that mirrors how you would connect with a SQL client, but using the MCP interface and your authentication token.

How to install

Prerequisites: ensure you have Node.js and npm installed on your system.

Install the MCP server globally so you can run it from anywhere.

npm install -g db4app-todo-mcp-server

Alternatively, you can run the MCP server without installation using npx.

npx db4app-todo-mcp-server

Configure your client using an MCP JSON entry. The following configuration snippet shows how to add the server to your mcp.json under mcpServers. This example uses npx to run the MCP server and passes the required environment variables.

{
  "mcpServers": {
    "db4app-todo": {
      "command": "npx",
      "args": [
        "-y",
        "db4app-todo-mcp-server@latest"
      ],
      "env": {
        "MCP_POSTGRES_URL": "postgres://postgres:YOUR_AUTH_TOKEN@YOUR_CONNECTION_ID.pg.db4.app",
        "MCP_SCHEMA": "todo_mcp"
      }
    }
  }
}

Additional sections

Security and connection details ensure your data remains protected while you manage todos from an MCP client.

Environment variables you’ll use in the configuration include the Postgres URL, the target schema, and optional connection details measured by token and connection IDs.

Available tools

add_todo

Add a new todo item with a title, optional description, category, priority, and due date.

mark_as_done

Mark a specific todo item as completed using its ID.

list_todos

List todos with optional filters for completion, category, and priority.

remove_todo

Delete a todo item by its ID.

Built by

VeilStrat

AI signals for GTM teams