Method searchCssDemos

MCP/server.js:441–508

(query, category, difficulty, limit = 5)

  }

  async searchCssDemos(query, category, difficulty, limit = 5) {
    debugLog(`🎨 Searching CSS demos with query: "${query}"`);
    
    return new Promise((resolve, reject) => {
      let sql = `
        SELECT * FROM css_inspiration 
        WHERE search_content LIKE ?
      `;
      let params = [`%${query}%`];

      if (category) {
        sql += ` AND category = ?`;
        params.push(category);
      }

      if (difficulty) {
        sql += ` AND difficulty_level = ?`;
        params.push(difficulty);
      }

      sql += ` ORDER BY title LIMIT ?`;
      params.push(limit);

      this.db.all(sql, params, (err, rows) => {
        if (err) {
          debugLog('❌ Error searching CSS demos:', err);
          reject(err);
          return;
        }

        debugLog(`✅ Found ${rows.length} CSS demos`);

        const formattedResults = rows.map(row => {
          const tags = JSON.parse(row.tags || '[]');
          const browserSupport = JSON.parse(row.browser_support || '{}');
          
          return {
            id: row.id,
            title: row.title,
            category: row.category,
            difficulty: row.difficulty_level,
            description: row.description,
            tags: tags,
            demo_url: row.demo_url,
            source_url: row.source_url,
            browser_support: browserSupport
          };
        });

        resolve({
          content: [
            {
              type: 'text',
              text: `Found ${formattedResults.length} CSS demos for "${query}":\n\n` +
                    formattedResults.map((demo, index) => 
                      `${index + 1}. **${demo.title}** (ID: ${demo.id})\n` +
                      `   🏷️ Category: ${demo.category} | Difficulty: ${demo.difficulty}\n` +
                      `   📝 ${demo.description}\n` +