Database

Every DYPAI project comes with a dedicated PostgreSQL database. This is the place where all your application's information is stored securely and permanently.

The best part? You don't need to be a database expert or write complex SQL to manage it.

Ways to Manage your Data

DYPAI gives you three simple ways to interact with your database:

1. Build with AI (Recommended)

The fastest way to manage your database is through your AI assistant. Using MCP, you can simply ask the AI to create or modify your data structure:

• "Create a table for 'orders' with total, date, and customer_id."
• "Add a 'phone' column to the users table."
• "Show me the relationship between products and categories."

2. Visual Editor

If you prefer a hands-on approach, our Visual Editor allows you to manage tables and columns with just a few clicks. It's like using a spreadsheet, but with the power of a professional database.

• Create and delete tables.
• Add, rename, or remove columns.
• View and edit your data directly in the browser.

3. Build your APIs

Once your data structure is ready, you can create custom REST Endpoints to interact with your database. Whether you need a simple CRUD or a complex workflow, you can build it using our API Builder or just ask the AI to do it for you via MCP.

Secure by Design

Security in DYPAI is managed at the API level. When you design your endpoints using the API Builder, you can define precise filtering rules and logic to ensure that users only access the information they are authorized to see.

This approach gives you full control over your data security within your custom workflows.

Backups

Don't worry about losing data. DYPAI performs automatic daily backups of your entire database, so you can restore your project to a previous state if needed.