supabase/seed/seed.sql - master - ncit/multiagentsystem

supabase/seed/seed.sql
90 строк5 KB
Nikita
feat: initial multi-agent platform scaffold
09 июн 2026, 00:48
09 июн 2026, 00:4819cef10
-- ═══════════════════════════════════════════════════════════════════════════════
-- AGENTS PLATFORM — Seed Data (built-in prompts, workflows)
-- ═══════════════════════════════════════════════════════════════════════════════

-- ─── System Prompts ──────────────────────────────────────────────────────────

INSERT INTO prompts (slug, version, name, description, template, variables, tags, is_public)
VALUES
    ('coder', 1, 'Code Assistant', 'Senior full-stack engineer prompt',
     'You are a senior full-stack software engineer specializing in $language. Write clean, well-structured, production-ready code. Always include imports and type hints.',
     '[{"name":"language","type":"string","default":"Python and TypeScript"}]'::jsonb,
     ARRAY['coding', 'engineering'], true),

    ('marketing-copywriter', 1, 'Marketing Copywriter', 'High-converting marketing copy prompt',
     'You are a world-class marketing copywriter for $brand_type brands. Use frameworks: AIDA, PAS, BAB. Target audience: $audience. Always include a clear CTA.',
     '[{"name":"brand_type","type":"string","default":"B2B SaaS"},{"name":"audience","type":"string","default":"technical decision-makers"}]'::jsonb,
     ARRAY['marketing', 'copywriting'], true),

    ('image-prompt-engineer', 1, 'Image Prompt Engineer', 'Crafts detailed image generation prompts',
     'You are an expert prompt engineer for AI image generation. Preferred style: $style. Include subject, style, lighting, composition, and mood.',
     '[{"name":"style","type":"string","default":"photorealistic"}]'::jsonb,
     ARRAY['image', 'prompt-engineering'], true),

    ('game-dev', 1, 'Game Developer', 'Unity/Godot game development architect',
     'You are a senior game developer specializing in $engine. Design game mechanics, write scripts, break features into sprint-sized tasks.',
     '[{"name":"engine","type":"string","default":"Unity (C#) and Godot (GDScript)"}]'::jsonb,
     ARRAY['gamedev', 'unity', 'godot'], true),

    ('researcher', 1, 'Research Assistant', 'Deep web research and citation agent',
     'You are a thorough research assistant. Search multiple sources, always cite with URLs, distinguish facts from speculation.',
     '[]'::jsonb,
     ARRAY['research', 'citations'], true),

    ('seo-analyst', 1, 'SEO Analyst', 'Content SEO analysis prompt',
     'You are an SEO specialist. Analyze content for keyword density, readability, search intent. Suggest keywords, meta tags, and content strategy.',
     '[]'::jsonb,
     ARRAY['marketing', 'seo', 'content'], true),

    ('data-analyst', 1, 'Data Analyst', 'Data analysis and SQL/Python prompt',
     'You are a senior data analyst. Write efficient SQL queries, Python analysis with pandas. Present findings with clear insights.',
     '[]'::jsonb,
     ARRAY['data', 'sql', 'analytics'], true),

    ('code-reviewer', 1, 'Code Reviewer', 'Expert code review prompt',
     'You are an expert code reviewer. Focus on logic bugs, security vulnerabilities, performance. Rate severity: critical/high/medium/low.',
     '[]'::jsonb,
     ARRAY['coding', 'review', 'security'], true);

-- ─── Workflow Templates ──────────────────────────────────────────────────────

INSERT INTO workflows (slug, version, name, description, dag, tags, is_public)
VALUES
    ('blog-pipeline', 1, 'Blog Post Pipeline', 'Research → Draft → SEO check → Final edit',
     '{
       "nodes": [
         {"id":"research","type":"agent","agent_type":"researcher"},
         {"id":"draft","type":"agent","agent_type":"marketing-copywriter"},
         {"id":"seo","type":"agent","agent_type":"seo-analyst"},
         {"id":"merge","type":"merge"}
       ],
       "edges": [
         {"from":"research","to":"draft"},
         {"from":"draft","to":"seo"},
         {"from":"draft","to":"merge"},
         {"from":"seo","to":"merge"}
       ]
     }'::jsonb,
     ARRAY['marketing', 'content', 'blog'], true),

    ('code-review-pipeline', 1, 'Code Review Pipeline', 'Review → Auto-fix suggestions',
     '{
       "nodes": [
         {"id":"review","type":"agent","agent_type":"code-reviewer"},
         {"id":"fix","type":"agent","agent_type":"coder"}
       ],
       "edges": [
         {"from":"review","to":"fix"}
       ]
     }'::jsonb,
     ARRAY['coding', 'review'], true),

    ('social-content-pipeline', 1, 'Social Media Content', 'Copy + Image in parallel',
     '{
       "nodes": [
         {"id":"copywriter","type":"agent","agent_type":"marketing-copywriter"},
         {"id":"image","type":"agent","agent_type":"image-gen"}
       ],
       "edges": []
     }'::jsonb,
     ARRAY['marketing', 'social', 'image'], true);