Built-in CMS & Database
Manage your content with a visual CMS and SQLite database. No external tools needed for your AI-built website.
Every Looops project includes a fully-featured content management system backed by a SQLite database. Create, manage, and display dynamic content without writing SQL.
Database Features
Visual Schema Editor
Design your database visually:
- Create tables with a click
- Define columns with various types
- Set relationships between tables
- Configure validations for data integrity
No SQL knowledge required—the AI handles the technical details.
Supported Column Types
| Type | Description | Example |
|---|---|---|
| Text | Short strings | Titles, names |
| Rich Text | Formatted content | Blog posts, descriptions |
| Number | Integers or decimals | Prices, quantities |
| Date | Date and time | Published date, event time |
| Boolean | True/false | Published status, featured |
| Image | File upload | Thumbnails, photos |
| Select | Predefined options | Category, status |
| Relation | Link to other tables | Author, category |
Type-Safe Queries
The AI generates TypeScript types for your database automatically. This means:
- Autocomplete for your data fields
- Compile-time errors if you access wrong fields
- Better code quality and fewer bugs
Content Management
Content Editor
Edit your content through a beautiful interface:
- Rich text editing with formatting toolbar
- Image uploads with drag-and-drop
- Inline preview of how content will look
- Autosave to prevent data loss
Content Collections
Organize content into collections (tables):
Example collections:
- Blog Posts
- Team Members
- Products
- Testimonials
- FAQ Items
Each collection has its own fields and can be connected to your pages.
Connecting to Pages
Dynamic Pages
Ask the AI to connect your content:
"Display blog posts from the database on the blog page"
The AI will:
- Query the database for posts
- Generate a listing component
- Create individual post pages
- Add pagination if needed
Content Components
Embed content anywhere:
"Show the 3 most recent testimonials in the hero section"
The AI creates components that pull live data from your database.
Common Use Cases
Blog
Tables needed:
- Posts (title, content, date, author, category)
- Categories (name, slug)
Features:
- Article listing with excerpts
- Category filtering
- Individual post pages
- Related posts
Portfolio
Tables needed:
- Projects (title, description, images, link, featured)
- Skills (name, category)
Features:
- Project grid with filtering
- Lightbox gallery
- Project detail pages
E-commerce (Simple)
Tables needed:
- Products (name, price, description, image, stock)
- Categories (name)
Features:
- Product listing
- Category pages
- Product detail pages
- (Payment integration coming soon)
Next Steps
- Working with the CMS — Detailed CMS guide
- Database Schema Design — Plan your data
- Forms & Submissions — Capture user data