todo-manager
使用SQLModel和Postgres管理待办事项操作(创建、读取、更新、删除)。当用户想要组织任务时使用。
📖 中文导读:使用SQLModel和Postgres管理待办事项操作(创建、读取、更新、删除)。当用户想要组织任务时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: todo-manager description: Manage Todo operations (Create, Read, Update, Delete) using SQLModel and Postgres. Use when the user wants to organize tasks.
Todo Management Skill
Executive Summary
This skill governs the lifecycle of Todos in the "Advanced AI-Todo" application. It ensures all operations are persistent, async-ready, and compliant with the project's technical mandates.
Operational Mandates
- Environment First: ALWAYS run
source .venv/bin/activatebefore any backend execution oruvcommand. - Dependency Management: Use
uvfor all package operations. Never use rawpip. - Connectivity: Connect to Gemini 2.5 Flash using the
AsyncOpenAIclass. - Docs Validation: Before proposing code changes to
SQLModelorFastAPI, call thecontext-7MCP server to verify the latest async patterns.
Execution Workflow
- Step 1: Planning: Check
SKILLS/SKILL.mdfor current project state. - Step 2: Documentation: Query MCP
context-7for "FastAPI SQLModel Postgres async best practices". - Step 3: Implementation:
- Use
AsyncOpenAIfor the chatbot logic. - Ensure Postgres connection strings are pulled from environment variables.
- Implement CRUD operations as async functions.
- Use
- Step 4: Verification: Run tests using
uv run pytest.
Examples
- Input: "Create a task to buy milk."
- Action: Invoke
todo-manager→ Search MCP for SQLModel patterns → Generate async code to insert into Postgres → Confirm with Gemini 2.5 Flash.