ALTER TABLE notes ADD COLUMN tags text[] DEFAULT '{}';
CREATE INDEX idx_notes_tags ON notes USING GIN(tags);

-- Single tag filter
SELECT * FROM notes WHERE 'work' = ANY(tags);

-- AND filter (note has all specified tags)
SELECT * FROM notes WHERE tags @> ARRAY['work', 'project'];

-- Prefix search across all tags
SELECT * FROM notes WHERE EXISTS (
  SELECT 1 FROM unnest(tags) t WHERE t LIKE 'wor%'
);

// ai-hub/index.ts
case "tags.suggest": {
  const { text, existing_tags } = params;
  const response = await groq.chat.completions.create({
    model: "llama-3.3-70b-versatile",
    messages: [{
      role: "user",
      content: `Suggest 3-5 tags for this text.
Existing tags: ${existing_tags.join(', ')}
Text: ${text}
Return JSON: {"tags": ["tag1", "tag2", ...]}`
    }],
    response_format: { type: "json_object" },
  });
  return JSON.parse(response.choices[0].message.content);
}

class TagInputField extends StatefulWidget {
  final List<String> initialTags;
  final String noteContent;
  final ValueChanged<List<String>> onChanged;

  @override
  Widget build(BuildContext context) {
    return Column(
      children: [
        Wrap(
          spacing: 8,
          children: _tags.map((tag) => Chip(
            label: Text('#$tag'),
            deleteIcon: const Icon(Icons.close, size: 16),
            onDeleted: () => _removeTag(tag),
            backgroundColor: const Color(0xFF1E3A5F),
          )).toList(),
        ),
        TextField(
          controller: _controller,
          decoration: const InputDecoration(hintText: 'Add tag (Enter to confirm)'),
          onSubmitted: _addTag,
        ),
        if (_tags.isEmpty)
          TextButton.icon(
            icon: const Icon(Icons.auto_awesome, size: 16),
            label: const Text('Suggest tags with AI'),
            onPressed: _suggestTags,
          ),
      ],
    );
  }

  Future<void> _suggestTags() async {
    final response = await Supabase.instance.client.functions.invoke(
      'ai-hub',
      body: {
        'action': 'tags.suggest',
        'text': widget.noteContent,
        'existing_tags': _tags,
      },
    );
    setState(() => _suggestedTags =
        List<String>.from(response.data['tags'] ?? []));
  }
}

// Save tags
await Supabase.instance.client
    .from('notes')
    .update({'tags': tags})
    .eq('id', noteId);

// Filter by tag
final notes = await Supabase.instance.client
    .from('notes')
    .select()
    .contains('tags', [selectedTag])
    .order('updated_at', ascending: false);

final result = await Supabase.instance.client.rpc('get_unique_tags');

CREATE OR REPLACE FUNCTION get_unique_tags()
RETURNS text[] AS $$
  SELECT ARRAY(
    SELECT DISTINCT unnest(tags) FROM notes
    WHERE user_id = auth.uid()
    ORDER BY 1
  );
$$ LANGUAGE sql SECURITY DEFINER;