# How to Vibe Code Your Own PosteAhora (and Stop Paying for It) > Social media on autopilot with AI agents - Site: https://posteahora.com - Category: Social Media & Automation - Verdict: **Serious undertaking** (45/100 vibecodeable) - Estimated effort: 4-6 weeks of part-time work ## Verdict Build a focused single-user subset with 3 key platforms, or keep paying if you genuinely need all 14 networks connected simultaneously. The core engineering challenge here is not the Next.js UI or the Kanban board, but wrestling with the 14 fragmented social platform APIs and building a fully functional Model Context Protocol server. While an AI coding agent can scaffold the database models and the REST API in hours, keeping 14 platform integrations alive through frequent API deprecations is a permanent maintenance treadmill. ### What you can't replicate - Pre-vetted enterprise developer apps and approved scopes across all 14 social media networks - The exact organic user acquisition and indie developer community mindshare ## What it does A social media management and scheduling platform featuring a built-in Model Context Protocol (MCP) server and REST API for AI agents. ### Core features - 14 fragmented social network platform integrations and OAuth handlers - Model Context Protocol (MCP) server for Claude, ChatGPT, and terminal tools - REST API gateway with token scopes and workspace isolation - Ideas Kanban board with backlog management and media attachment rules - Post scheduler with background execution crons and queue management - Media pre-signed upload pipeline and storage ## The business ### Pricing - Basic: $2.79/mo — Scheduling and publishing essentials - Essentials: $4.89/mo — For creators who want insights and automation - Pro: $9.09/mo — Full power for professionals and agencies Founded 2026. Team size: 1. ## The hard parts - Maintaining official API tokens, scopes, and rapidly changing payload formats across 14 distinct social networks - Building a secure, stateful MCP server transport layer that maps natural language tool calls to backend publishing actions - Reliable background scheduling cron execution ensuring zero dropped jobs or double-posting across timezone boundaries - Handling chunked video uploads and platform-specific media container requirements (e.g. Instagram Reels, TikTok videos) ## How to vibe code PosteAhora ### Prerequisites - Node.js (free): Runtime for running the Next.js full-stack application and MCP server - GitHub (free): Source code repository and CI/CD deployment connection ### Recommended AI tools - Claude Code: Best-in-class agentic coding tool for scaffolding complex backend routes, MCP servers, and API gateways - Cursor: Ideal AI code editor for iterating on dashboard UI components and managing multi-file diffs ### Stack - Frontend: Next.js with Tailwind CSS and shadcn/ui components - Backend: Next.js API routes / Edge functions and a custom Model Context Protocol (MCP) server transport - Database: Turso (SQLite at the edge) - Auth: better-auth - Payments: Stripe - Other: Vercel AI SDK for LLM interactions, Cloudflare R2 for pre-signed media object storage ### Hosting - Vercel (Hosting the Next.js frontend, API endpoints, and cron jobs): $0-20/mo - Turso (Serverless SQLite database for posts, accounts, and ideas kanban): $0/mo ### Build guide 1. **Project Scaffolding and Database Schema** — Initialize the Next.js project with Tailwind CSS, configure Turso database connectivity, and define relational tables for accounts, workspaces, posts, and ideas. ``` Create a new Next.js project configured with TypeScript and Tailwind CSS. Set up Drizzle ORM connected to Turso SQLite. Create database tables for: 1) workspaces (id, name, is_personal, role), 2) connected_accounts (id, workspace_id, platform, platform_username, platform_account_id, access_token, refresh_token, is_connected), 3) ideas (id, workspace_id, title, caption, status, tags, media_urls), and 4) posts (id, workspace_id, caption, status, scheduled_at, account_mappings, media_urls). Include proper foreign key constraints, indexes on scheduled_at and workspace_id, and Zod validation schemas for all write operations. ``` 2. **Authentication and Workspace Management** — Implement secure user authentication with better-auth and workspace context isolation for API keys and data access. ``` Integrate better-auth into the Next.js app supporting email/password and session management. Implement workspace middleware that ensures every user belongs to at least one personal workspace upon signup. Create settings pages to manage workspaces, invite team members, and generate API keys (prefixed with pah_live_ or pah_test_) with granular scopes like posts:read, posts:write, ideas:read, ideas:write, and accounts:read. ``` 3. **REST API Gateway and Core CRUD Endpoints** — Build the key-authenticated REST API gateway matching the PosteAhora specification for accounts, ideas, and posts. ``` Implement a key-authenticated REST API route handler under /api/v1/[...route] (or matching /functions/v1/api prefix). Support Bearer token validation against the API keys table, scope checking (403 on missing scopes), and rate limiting. Implement endpoints: GET /accounts, GET /workspaces, GET/POST/PATCH/DELETE /ideas, and GET/POST/PATCH/DELETE /posts. Ensure all queries strictly filter by the workspace associated with the validated API key. ``` 4. **Model Context Protocol (MCP) Server Integration** — Expose an MCP server layer so AI coding assistants like Claude and Cursor can interact with the scheduling backend via natural language. ``` Build a Model Context Protocol (MCP) server implementation using TypeScript that exposes tools for AI agents: list_accounts, list_ideas, create_idea, update_idea, list_posts, create_post, and schedule_post. The MCP server should authenticate requests using a configured API key and route tool execution calls directly through the internal service layer, allowing tools like Claude Desktop or Claude Code to manage content calendars via chat. ``` 5. **Media Storage and Pre-signed Uploads** — Implement cloud storage integration with Cloudflare R2 / S3 pre-signed upload URLs for handling images and videos. ``` Create a media upload endpoint (/api/media/upload-url) that generates secure pre-signed upload URLs for Cloudflare R2 or S3-compatible storage. Build frontend components allowing users to upload images and videos directly to object storage, returning public URLs to attach to ideas and scheduled posts. ``` 6. **Dashboard UI, Kanban Board, and Post Scheduler** — Build the visual web dashboard featuring the ideas kanban board, multi-platform post composer, and calendar view. ``` Build a responsive web dashboard using Tailwind CSS and shadcn/ui primitives. Include: 1) An interactive Ideas Kanban board with columns (unassigned, todo, in_progress, done) supporting drag-and-drop status changes, 2) A multi-platform post composer allowing selection of connected accounts and rich caption input, 3) A calendar/schedule view displaying queued and published posts, and 4) An API keys management screen. ``` 7. **Background Worker & Social Publishing Pipeline** — Set up scheduled cron triggers to check and dispatch pending posts to connected social platform APIs. ``` Implement a background worker or Vercel Cron endpoint (/api/cron/publish) that runs every minute, queries posts where status = 'scheduled' and scheduled_at <= current timestamp, and attempts publishing. For initial testing, implement robust mock publishing handlers for X, LinkedIn, and Instagram, updating post status to 'published' or 'failed' with error logging on failure. ``` ### Cost vs paying **Starting costs (one-time):** - Custom Domain (optional): $12/year - Total: ~$12 one-time **Ongoing costs (monthly):** - Vercel / Cloudflare hosting: $0-5/mo - Turso Database: $0/mo - Total: ~$0-5/mo - Paying for the SaaS instead: $4.89/mo (Essentials plan) - Build time: 35-50 hours - AI tool credits: $20/mo (Claude Pro / Cursor) - Break-even: Not a business investment; build for custom MCP workflows and learning. ## Sources - [PosteAhora Official Website](https://posteahora.com) - [PosteAhora Docs & API Reference](https://posteahora.com/docs) - [Uneed — PosteAhora Product Profile](https://www.uneed.best/tool/posteahora)