AI Powered Content Creation Assistant

🧠 内容创建助手

一个由人工智能驱动的自主代理：

• 研究 一个话题
• 写入 一篇高质量的博客文章
• 商店 Neon PostgreSQL数据库中的内容
• 和 标记完成 使用自定义 done 工具

使用 @inngest/agent工具包, 谷歌双子座，以及 Smithery的MCP 通过AI实现无服务器SQL控制。

______________________________________________________________________

✨ 特性

______________________________________________________________________

🔄 代理流程（文本流程图）

START
  ↓
Receive Prompt (e.g., "Write a blog on urban gardening")
  ↓
[contentCreatorAgent Activated]
  ↓
1️⃣ Research Topic
  ↓
2️⃣ Check/Create Database Tables (via Neon MCP)
  ↓
3️⃣ Generate Blog Content (via Gemini 1.5 Flash)
  ↓
4️⃣ Store Content + Metadata in DB
  ↓
5️⃣ Call `done` Tool (store summary, mark complete)
  ↓
[Router Checks]
 └── If completed = true → Stop
 └── Else → Continue
  ↓
END

______________________________________________________________________

🚀 入门指南

1.克隆和安装

git clone https://github.com/your-org/content-creation-assistant.git
cd content-creation-assistant
npm install

2.配置环境变量

# .env
SMITHERY_API_KEY=your-smithery-key
GEMINI_API_KEY=your-google-gemini-key
# or: GOOGLE_GENAI_API_KEY=...

3.本地运行

npx tsx index.ts

输出：

🚀 Content Creation Assistant running on http://localhost:3010
🗄️ Connected to Neon PostgreSQL via MCP

4.内置开发服务器（可选）

npx inngest-cli@latest dev -u http://localhost:3010/api/inngest

打开： http://localhost:8288

5.尝试提示

发送POST请求：

POST http://localhost:3010
{
  "prompt": "Create a 1000-word blog post on sustainable urban gardening with SEO tips."
}

______________________________________________________________________

🗄️ 数据库模式

CREATE TABLE IF NOT EXISTS content_pieces (
  id SERIAL PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  content TEXT NOT NULL,
  topic VARCHAR(255),
  content_type VARCHAR(100) DEFAULT 'blog_post',
  word_count INTEGER,
  keywords TEXT[],
  research_summary TEXT,
  created_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS research_sources (
  id SERIAL PRIMARY KEY,
  content_id INTEGER REFERENCES content_pieces(id),
  source_title VARCHAR(255),
  source_summary TEXT,
  relevance_score INTEGER DEFAULT 5,
  created_at TIMESTAMP DEFAULT NOW()
);

______________________________________________________________________

📁 文件结构

.
├── index.ts           # Main logic (agent, tool, server)
├── package.json
├── tsconfig.json
└── README.md

______________________________________________________________________

🛠 定制选项

______________________________________________________________________

......................................................................................... ......................................................................................... ......................................................................................... ......................................................................................... ......................................................................................... ......................................................................................... .........................................................................................

📜 许可证

麻省理工学院©2025 Hrushikesh Kadudula