DocsDatabase & Schema

Free

Database & Schema

Browse and edit your app's data, design schemas visually, and choose between Firestore and PostgreSQL for your storage needs.

Database Browser

The Database Browser lets you view, edit, and delete records directly in the app editor. Inspect your app's data without leaving GenMB — no external database tools needed.

Open the Database Browser

Click the database icon in the app editor sidebar to open the Database Browser panel.

Browse collections and tables

View real-time data from your app's Firestore collections or PostgreSQL tables. All records update live as your app writes data.

Filter and sort records

Filter records by field values to find specific data quickly. Sort by any column in ascending or descending order to organize your view.

Edit records inline

Click a cell to modify its value directly. Changes are saved to the database immediately.

Delete records safely

Delete records with a confirmation dialog to prevent accidental data loss.

The Database Browser is available on all plans including Free. You do not need a Pro subscription to inspect and manage your app's data.

Schema Designer

The Schema Designer is a visual table editor for defining your database structure. Create tables, add columns with types, and define relationships between tables — all through a graphical interface.

Open the Schema Designer

Open the Schema Designer from the sidebar to start designing your database schema visually.

Create tables and columns

Create tables by naming them and adding columns with specific data types. Set column constraints such as required, unique, default values, and primary keys.

Define relationships

Define relationships between tables — one-to-one, one-to-many, or many-to-many — to model your data structure accurately.

Auto-provisioning

Changes to the schema are auto-provisioned. GenMB applies them to your database automatically — no migration scripts needed.

DataConnect Provisioning

When you define a schema in Schema Designer, GenMB automatically provisions a PostgreSQL database via DataConnect. This happens behind the scenes — you do not need to configure any database connection settings.

Design your schema upfront if you know your data model. It saves time versus restructuring later. The Schema Designer gives you a visual overview that makes it easy to spot missing relationships or redundant fields.

Schema Designer is a Pro feature. Free plan users can use the Database Browser for manual data management.

Firestore vs PostgreSQL

GenMB supports two database backends depending on your data needs. Choose the right one based on your app's requirements.

Firestore (NoSQL)

A NoSQL document database. Best for simple key-value data, user profiles, settings, and content. No schema required. Available on all plans.

PostgreSQL via DataConnect

A relational database with full SQL support. Best for structured data with relationships, joins, and complex queries. Provisioned automatically when you use Schema Designer.

Firestore is the default for generated apps. The AI uses Firestore collections when your app needs data storage. PostgreSQL is provisioned when you define a schema in Schema Designer or when the AI detects relational data requirements.

You can use both in the same app — Firestore for simple data and PostgreSQL for structured, relational data. Start with Firestore for prototyping and move to PostgreSQL when you need relational queries.

Data Types

Both Firestore and PostgreSQL support a variety of data types for your columns and fields.

Type	Description
String	Text values of any length. Used for names, descriptions, URLs, and general text.
Number	Integer or floating-point numeric values. Used for quantities, prices, and counts.
Boolean	True or false values. Used for flags, toggles, and status fields.
Timestamp	Date and time values with timezone support. Used for created/updated dates and scheduling.
Array	Ordered lists of values. Used for tags, categories, and multi-value fields (Firestore only).
Map/JSON	Nested key-value objects. Used for structured metadata and configuration (Firestore only).

Tips

Make the most of GenMB's database features with these recommendations.

Quick Data Inspection

Use the Database Browser for quick data inspection — it is faster than writing queries or using external tools.

Data Insights

Use Data Insights (Pro) to query your data with natural language if you need analytics or reports without writing SQL.

Start with Firestore for prototyping — it requires no schema and is flexible. Move to PostgreSQL when you need relational queries or complex joins.

FAQs

Do I need to set up a database manually?▾

No. GenMB automatically provisions and manages databases for your apps. Firestore is available by default, and PostgreSQL is auto-provisioned when you use Schema Designer or the AI detects relational data needs.

Is the Database Browser available on Free plans?▾

Yes. The Database Browser is available on all plans. Schema Designer requires the Pro plan or higher.

Can I use SQL with my GenMB app?▾

Yes, when using PostgreSQL via DataConnect. Define your schema in Schema Designer and use the Data Client SDK to run queries. Firestore uses its own query API instead of SQL.

What happens to my data if I delete my app?▾

Deleting an app removes all associated data including Firestore collections and PostgreSQL tables. Export your data before deleting if you need to keep it.

Ready to build?

Create your first app for free — no credit card required.

Services & SDKs Backend Agents