feat(mcpb): add MCP prompts for welcome message and examples

jqnatividad · claude · jqnatividad · commit 2672a74b45a0 · 2026-01-07T18:33:53.000-05:00
Added two interactive prompts that users can select in Claude Desktop: 1. **Welcome Prompt** - Provides: - Introduction to qsv and its capabilities - Privacy & security assurances (100% local processing) - Quick start examples - Common commands reference - Getting started guidance 2. **Examples Prompt** - Shows: - Data exploration patterns - Data cleaning workflows - Data transformation examples - Complex multi-step pipelines - Format conversion usage How it works: - Users can select prompts from Claude Desktop's UI - Prompts appear as pre-formatted conversations - Provides onboarding for new users - Reference guide for common tasks Changes to manifest.json: - Added "prompts" array with welcome and examples prompts Changes to mcp-server.ts: - Added ListPromptsRequestSchema and GetPromptRequestSchema imports - Added "prompts" capability to server - Implemented registerPromptHandlers() method - Added handlers for prompts/list and prompts/get requests - Created rich markdown content for both prompts Updated description to clarify restricted filesystem access. Regenerated qsv-mcp-server.mcpb. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
diff --git a/.claude/skills/manifest.json b/.claude/skills/manifest.json
@@ -137,6 +137,18 @@
     }
   ],
   "tools_generated": true,
+  "prompts": [
+    {
+      "name": "welcome",
+      "description": "Welcome message and quick start guide for qsv",
+      "arguments": []
+    },
+    {
+      "name": "examples",
+      "description": "Show common qsv usage examples",
+      "arguments": []
+    }
+  ],
   "compatibility": {
     "platforms": ["darwin", "win32", "linux"]
   },
diff --git a/.claude/skills/qsv-mcp-server.mcpb b/.claude/skills/qsv-mcp-server.mcpb
diff --git a/.claude/skills/src/mcp-server.ts b/.claude/skills/src/mcp-server.ts
@@ -13,6 +13,8 @@ import {
   ListResourcesRequestSchema,
   ListToolsRequestSchema,
   ReadResourceRequestSchema,
+  ListPromptsRequestSchema,
+  GetPromptRequestSchema,
 } from '@modelcontextprotocol/sdk/types.js';
 
 import { SkillLoader } from './loader.js';
@@ -57,6 +59,7 @@ class QsvMcpServer {
         capabilities: {
           tools: {},
           resources: {},
+          prompts: {},
         },
       },
     );
@@ -100,6 +103,11 @@ class QsvMcpServer {
     this.registerResourceHandlers();
     console.error('Resource handlers registered');
 
+    // Register prompt handlers
+    console.error('About to register prompt handlers...');
+    this.registerPromptHandlers();
+    console.error('Prompt handlers registered');
+
     console.error('QSV MCP Server initialized successfully');
   }
 
@@ -414,6 +422,231 @@ class QsvMcpServer {
     });
   }
 
+  /**
+   * Register prompt handlers
+   */
+  private registerPromptHandlers(): void {
+    // List prompts handler
+    this.server.setRequestHandler(ListPromptsRequestSchema, async () => {
+      return {
+        prompts: [
+          {
+            name: 'welcome',
+            description: 'Welcome message and quick start guide for qsv',
+            arguments: [],
+          },
+          {
+            name: 'examples',
+            description: 'Show common qsv usage examples',
+            arguments: [],
+          },
+        ],
+      };
+    });
+
+    // Get prompt handler
+    this.server.setRequestHandler(GetPromptRequestSchema, async (request) => {
+      const { name } = request.params;
+
+      if (name === 'welcome') {
+        return {
+          messages: [
+            {
+              role: 'user',
+              content: {
+                type: 'text',
+                text: 'Hello! Tell me about qsv and how to get started.',
+              },
+            },
+            {
+              role: 'assistant',
+              content: {
+                type: 'text',
+                text: `# Welcome to qsv Data Wrangling! 🎉
+
+I'm your qsv assistant, ready to help you wrangle CSV, Excel, and JSONL files with ease.
+
+## What is qsv?
+
+qsv is a blazingly-fast command-line toolkit with 66 commands for:
+- ✅ **Transforming** data (select, rename, replace, apply)
+- ✅ **Analyzing** data (stats, frequency, describe)
+- ✅ **Validating** data (schema, validate, safenames)
+- ✅ **Querying** data with SQL (sqlp, joinp)
+- ✅ **Converting** formats (Excel, JSONL, Parquet)
+
+## 🔒 Privacy & Security
+
+- **100% local processing** - your data never leaves your machine
+- **Restricted access** - only works with directories you approve
+- **No cloud uploads** - all operations happen on your computer
+
+## Quick Start
+
+**1. List your CSV files**
+\`\`\`
+List CSV files in my Downloads folder
+\`\`\`
+
+**2. Preview a file**
+\`\`\`
+Show me the first few rows of data.csv
+\`\`\`
+
+**3. Get statistics**
+\`\`\`
+Calculate statistics for the price column in sales.csv
+\`\`\`
+
+**4. Filter and transform**
+\`\`\`
+From customers.csv, remove duplicates and sort by revenue
+\`\`\`
+
+## Common Commands
+
+- **qsv_stats** - Calculate statistics (sum, mean, min, max, etc.)
+- **qsv_frequency** - Show value distributions
+- **qsv_search** - Filter rows with regex patterns
+- **qsv_select** - Select/exclude columns
+- **qsv_pipeline** - Chain multiple operations
+
+## Need Help?
+
+- Ask "Show me qsv examples" for more usage patterns
+- Say "List available qsv commands" to see all 66 commands
+- Ask about specific operations like "How do I deduplicate a CSV?"
+
+## Ready to Start?
+
+Just tell me what you want to do with your data, and I'll help you use qsv to get it done!`,
+              },
+            },
+          ],
+        };
+      }
+
+      if (name === 'examples') {
+        return {
+          messages: [
+            {
+              role: 'user',
+              content: {
+                type: 'text',
+                text: 'Show me common qsv usage examples',
+              },
+            },
+            {
+              role: 'assistant',
+              content: {
+                type: 'text',
+                text: `# Common qsv Usage Examples
+
+## Data Exploration
+
+**Preview a CSV file:**
+\`\`\`
+Show me the first 10 rows of data.csv
+\`\`\`
+
+**Get column statistics:**
+\`\`\`
+Calculate statistics for all columns in sales.csv
+\`\`\`
+
+**Show value frequency:**
+\`\`\`
+Show the frequency distribution of the 'status' column in orders.csv
+\`\`\`
+
+## Data Cleaning
+
+**Remove duplicates:**
+\`\`\`
+Remove duplicate rows from customers.csv and save as cleaned.csv
+\`\`\`
+
+**Filter rows:**
+\`\`\`
+From sales.csv, keep only rows where the price column is greater than 100
+\`\`\`
+
+**Fix column names:**
+\`\`\`
+Make all column names in data.csv safe (remove special characters)
+\`\`\`
+
+## Data Transformation
+
+**Select columns:**
+\`\`\`
+From users.csv, select only the name, email, and city columns
+\`\`\`
+
+**Rename columns:**
+\`\`\`
+In data.csv, rename 'old_name' to 'new_name'
+\`\`\`
+
+**Sort data:**
+\`\`\`
+Sort sales.csv by revenue in descending order
+\`\`\`
+
+## Complex Workflows
+
+**Multi-step pipeline:**
+\`\`\`
+From customers.csv:
+1. Remove duplicate emails
+2. Keep only customers from California
+3. Sort by revenue descending
+4. Take top 100
+5. Save as top_customers.csv
+\`\`\`
+
+**Join datasets:**
+\`\`\`
+Join orders.csv with customers.csv on customer_id
+\`\`\`
+
+## Data Validation
+
+**Check schema:**
+\`\`\`
+Validate sales.csv against this schema: price is number, date is date format
+\`\`\`
+
+**Find data quality issues:**
+\`\`\`
+Check products.csv for empty values, duplicates, and invalid data
+\`\`\`
+
+## Format Conversion
+
+**Excel to CSV:**
+\`\`\`
+Convert spreadsheet.xlsx to CSV format
+\`\`\`
+
+**CSV to JSONL:**
+\`\`\`
+Convert data.csv to JSONL format
+\`\`\`
+
+---
+
+**Try any of these patterns with your own files!** Just describe what you want to do, and I'll use qsv to make it happen.`,
+              },
+            },
+          ],
+        };
+      }
+
+      throw new Error(`Unknown prompt: ${name}`);
+    });
+  }
+
   /**
    * Start the server
    */
