skills.rest
ramshan00
ramshan00COMMUNITY
Explore all skills by this author →
GitHub

mcp-todo-skill

Generates a stateless FastMCP server with five PostgreSQL-backed todo management tools.

Updated Feb 8, 2026
Search Tags:#postgresql#sqlmodel#code generation#mcp#todo#fastmcp#user isolation
One-click install
npx skills add https://github.com/ramshan00/hackaton --skill mcp-todo-skill-ramshan00
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mcp-todo-skill
Source: https://github.com/ramshan00/hackaton/tree/main/Hackathon2-phase3/.claude/skills/mcp-todo-skill
Command: npx skills add https://github.com/ramshan00/hackaton --skill mcp-todo-skill-ramshan00

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires mcp, sqlmodel, psycopg2-binary, and includes references (resource) and assets (resource) components.

What problem does it solve? Building a Model Context Protocol server for task management from scratch requires boilerplate for tool registration, database sessions, and user isolation. This Skill generates a complete, stateless MCP todo server so conversational agents can manage per-user tasks without custom plumbing. ## Core Features & Use Cases - Five CRUD Tools: Implements add_task, list_tasks, complete_task, delete_task, and update_task via FastMCP decorators. - Stateless User Isolation: Every tool takes user_id as its first argument and filters all SQL queries by it, with no in-memory state. - PostgreSQL Persistence: Uses SQLModel sessions per request so all state lives in the database. - Use Case: You are building an AI assistant that manages user todos. Use this Skill to generate the MCP server, register it in your MCP config, and let the agent call the todo tools on behalf of authenticated users. ## Quick Start Ask the AI to use the mcp-todo-skill to generate a stateless MCP todo server with PostgreSQL persistence and register it in the MCP configuration.

Frequently Asked Questions about mcp-todo-skill

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build an MCP server for todo management in Python?▼

Use FastMCP from the mcp SDK to define tools with the @mcp.tool() decorator, then implement CRUD functions backed by SQLModel sessions. This Skill generates a server with add, list, complete, delete, and update tools that persist to PostgreSQL.

How do I enforce user isolation in MCP tools?▼

Pass user_id as the first argument to every tool and filter all SQL queries with WHERE user_id = ?. Keep no state in server memory so each invocation is an independent database transaction.

Does FastMCP support async tools and type hints?▼

Yes, FastMCP tools can be defined with def or async def, and type hints on parameters drive automatic schema generation. The tool description comes from the function docstring.

What databases work with this MCP todo server?▼

The generated server targets PostgreSQL via SQLModel with psycopg2-binary or asyncpg, configured through the DATABASE_URL environment variable. The engine setup can be adapted to other SQLModel-supported databases.

What are the limitations of this MCP todo server?▼

It does not handle user authentication, create the database schema, or deploy the server. Authentication is assumed to happen upstream, and only local execution instructions are provided.

Related Skills

Explore More Software Engineering Skills→
clawdataclawdata
24

postgres

Manage and query PostgreSQL databases from the command line via psql.

Official
Intermediate
open-haxopen-hax
6

mcp-server-integration

Configure MCP servers and register tools for OpenCode workflows.

Official
Intermediate
92Bilal2692Bilal26

chatkit-botbuilder

Build ChatKit chatbots with FastAPI, Next.js, and MCP tool integration.

Community
Advanced
hashgraphhashgraph
10

hedera

Direct AI agents to current Hedera documentation and official resources.

Official
Basic