graph TD
    %% Users
    U1[👨‍💻 Developer]
    U2[👔 Admin]
    U3[👤 End User]

    %% User Interfaces
    A[formmate - AI Schema Builder /mate]
    C[AdminApp /admin]
    D[Portal /portal]
    P[Pages]

    %% Backend Services
    B[FormCMS Backend /api]
    E[AI<br>Gemini / OpenAI]

    %% User → UI
    U1 -->|Build Schema & UI| A
    U2 -->|Manage Content| C
    U3 -->|View & Engage| D
    U3 -->|Browse Content| P

    %% UI → Backend
    A --> B
    A --> E
    C --> B
    D --> B
    P --> B

The "brain" of the ecosystem. This tool leverages LLMs to architect your data models and design your UI. It translates your natural language requirements into technical configurations that the system understands.

• Schema Generation: Describe your domain in natural language, get normalized database schemas
• Data Seeding: Generate realistic sample data with relational integrity
• Query Building: Create GraphQL queries from prompts, auto-convert to REST endpoints
• UI Generation: Generate HTML/CSS pages connected to your data
• Engagement Features: Add likes, shares, views, toplist, page tracking, and user avatars via prompts
• Version History: Access and rollback all generated content in the portal

The core high-performance engine built with ASP.NET Core (C#).

• REST & GraphQL: Automatically exposes APIs for every entity you define
• Normalized Storage: Optimized for speed (Sqlite, Postgres, SQL Server, MySQL supported)
• User Engagement: Built-in likes, bookmarks, shares, views, toplist, and page tracking with buffered writes
• Social Features: Notifications, comments system, and popularity scoring
• Scale: Designed to handle millions of records and high-concurrency environments

• P95 latency under 200ms for the slowest APIs
• Throughput over 2,400 QPS per application node
• Support for complex queries (5-table joins over 1M rows)
• Efficient handling of large tables (100M+ records for user activities)

A sleek, React-based administrative interface.

• Manage your content data (CRUD operations)
• Edit related content inline
• Manage assets (images, files) with local or cloud storage
• Built-in audit logging and publication workflows

Server-side rendered pages for end users to browse content.

1. Template Storage: Handlebars templates are saved to FormCMS database
2. Server Rendering: FormCMS backend reads the template, executes the page's query definition to load data, and renders HTML
3. Dynamic Hydration: After the page loads in the browser, Alpine.js fetches and displays dynamic social data (likes, views, etc.)

• SEO Optimized: Server-rendered HTML for search engine visibility
• Handlebars Templating: Flexible server-side rendering with Handlebars
• Built-in Routing: Automatic routes based on page configuration
• Cached for Performance: Response caching for fast page loads
• Social Features: Built-in likes, shares, views, and toplist

A personalized portal where users can manage their social engagement and content.

• History: View previously accessed content
• Liked Items: Browse and manage liked content
• Bookmarked Items: Organize saved content with folders