Database

Every app includes a database. Proyecta creates schema from your descriptions. View, edit, and manage data from the Database tab.

Every Proyecta app comes with a built-in database — no setup required. It’s a real-time, document-oriented database with automatic reactivity — your UI updates instantly when data changes.

How does the database work?

When you describe features to the AI, it creates the database schema automatically:

• "Add a blog with posts and comments" → creates posts and comments tables
• "Users should be able to save favorites" → creates a favorites table with user relationships
• "Track order history" → creates an orders table with proper indexes

You don’t need to design the schema. Describe the functionality and user experience you want, and the AI handles the rest.

View and manage data

Open Dashboard > Data to browse and manage your database:

• Table list — all your tables with document counts
• Record browser — paginated view of records in any table
• Create records — add new records with a form editor
• Edit records — update individual fields
• Delete records — remove records with confirmation

The Data tab automatically discovers table schemas and infers field types, so you can browse and edit records without any configuration.

What about the AI?

The AI is the most powerful way to read and write data today. Ask it directly:

• "Show me the last 10 users who signed up"
• "Add a test user with email test@example.com"
• "Set every order from last week to status=shipped"
• "Bulk insert these 20 products"
• "Drop the old temp_imports table"

The AI can read and modify any data, with your approval on destructive operations.

Infrastructure Databases

If you need a traditional relational database in addition to the built-in database, you can add infrastructure services:

• PostgreSQL — Full relational database with SQL support
• MySQL — Alternative relational database
• MongoDB — Document database
• Redis — In-memory data store / cache

Add these from the Services panel in the builder. See Dev Machines for details.

FAQ

Is my data backed up?

Data persistence and replication are handled automatically. For infrastructure databases (PostgreSQL, etc.), backups are not currently automated.

Can I export my data?

Yes. Use the Database tab to browse and export data, or see Export Data for more options.

Can I edit data without going through the AI?

Yes — use Dashboard > Data to browse, create, edit, and delete records directly.

Coming soon

• Inline cell editing in the Database tab
• CSV import for bulk loading
• Search and filter across records