---

name: siso-internal category: integration-connectivity/mcp-integrations version: 1.0.0 description: Complete guide to SISO Internal task management and operations system with Claude Code author: blackbox5/mcp verified: true tags: [mcp, siso, task-management, projects, crm]

SISO Internal Task Management System Skills

Database: SISO Internal Supabase

• Project Ref: avdgyrepwrvsvwgxrccr
• URL: https://avdgyrepwrvsvwgxrccr.supabase.co
• Access: Available globally in all Claude instances

Core Tables:

• projects - Project tracking and management
• tasks - Individual task items with status tracking
• clients - Client information and relationships
• partnerships - Partner relationships and revenue tracking
• issues - Bugs and issues tracking
• team - Team member information and availability
• communications - Internal notes, client comms, meeting notes

This is your single source of truth for all project work, task assignments, and client management.

Query SISO first to understand what's on your plate, then update it as you make progress. Cross-reference SISO tasks with actual codebase work.

<available_skills> <skill_group name="Project Management"> Query projects from SISO Show all active projects assigned to me Filter by status (active, completed, archived) Filter by assignee Filter by client Filter by priority level Create a new project in SISO Create a new project for client Acme with priority high Client reference Project name Project details Initial status Priority level Team member assignment Project start date Project deadline Update project status and details Update project status to 'in_progress' </skill_group>

<skill_group name="Task Management"> Query tasks from SISO Show all my tasks for today Filter by assignee Filter by status Filter by project Filter by priority Filter by due date Create a new task in SISO Create task: implement homepage with priority high Associated project Task title Task details Assignee Initial status Task priority Task deadline Time estimate Task tags/labels Update task status and progress Mark task 456 as complete Log time spent on a task Log 2 hours for task 123 </skill_group>

<skill_group name="Client Management"> Query clients from SISO Show all active clients Filter by status (active, inactive, prospect) Filter by industry Filter by location Create a new client in SISO Add new client Acme Corp with email contact@example.com Client company name Primary contact Contact email Contact phone Client status Client industry Additional notes </skill_group>

<skill_group name="Partnership Management"> Query partnerships from SISO Show all active partnerships by revenue Create a new partnership Create partnership with Acme Corp with revenue share 20% </skill_group>

<skill_group name="Issue Tracking"> Query issues from SISO Show all open critical issues Filter by status (open, in_progress, resolved) Filter by severity Filter by project Filter by assignee Create a new issue in SISO Report bug: login not working Related project Issue title Issue details Severity level Assignee Initial status </skill_group>

<skill_group name="Team Coordination"> Query team members Show all team members by role Reassign tasks or projects Assign task 123 to john </skill_group>

<skill_group name="Communications"> Log a communication note Record decision: use React for frontend Related project Communication type Communication content People involved Who logged it Query communications log Show recent communications for project 123 </skill_group> </available_skills>

<best_practices> Check SISO before starting work Update task status daily Log important communications Use SISO as single source of truth Cross-reference projects Track time accurately Review tasks before meetings Assign tasks clearly Update SISO after completing work Get project context from SISO Skip updating task status Work without checking assignments Forget to log decisions Ignore priority levels Miss deadlines Duplicate work Work on wrong tasks Lose track of time </best_practices>

<error_handling> Can't find project Check project name spelling Verify project exists in SISO Use partial match with LIKE Tasks not showing Check assigned_to field Verify task status filter Check due_date range Client missing Search for variations of name Check if client is archived Verify client status Permission denied Verify SISO credentials Check table permissions Ensure RLS policies allow access </error_handling>

<integration_notes> SISO Internal Supabase Task management, project tracking, client information "Show my tasks for today" "Get client Acme details" "Create task for project 123" Lumelle Supabase Application data, partner platform, customer features "Get all products" "Show recent orders" "Create new user account" Use SISO for internal operations, Lumelle for application data Lumelle Cross-Reference Projects Sync Status Updates Client Handoff (when Lumelle becomes active client) </integration_notes>

Copy  -- Get recent communications
  SELECT * FROM communications
  WHERE project_id = (SELECT id FROM projects WHERE name = 'Acme Website')
  ORDER BY created_at DESC
  LIMIT 10;
</sql>

<quick_reference> "What are my tasks today?" "What's my highest priority task?" "Show my deadlines this week" "Show status of all active projects" "Get tasks for Lumelle project" "What's the timeline for Acme website?" "Show team workload" "Who's available for new tasks?" "What's john working on?" "Get details for Acme Corp" "Show recent communications with client" "What projects do we have for Acme?" </quick_reference>

<data_integrity>

<advanced_features> Reporting Generate project status report Create client summary Show team velocity Calculate project profitability Analytics Get task completion trends Show revenue by partnership Analyze team performance Track issue resolution time Forecasting Predict project completion date Estimate resource needs Forecast revenue Plan team capacity </advanced_features>