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. It also supports inline cell editing for scalar fields (number, short text, boolean) — click a cell to edit directly; complex or JSON fields open the full-form editor. A search bar in the toolbar filters records client-side across the loaded page.

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 directly — ask it to add, update, or delete records. For safety, the auth-managed users table is write-protected and cannot be modified through the AI.

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 by describing them to the AI, or by configuring them in your proyecta.config.json. 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?

Data export from the Data tab is not yet available. You can browse records in Dashboard > Data, or ask the AI to export your data. See Export Data for other export paths.

Can I edit data without going through the AI?

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

Coming soon

• CSV import for bulk loading