Database

The Database panel in your Workspace shows data collected from your site, such as form submissions, contact messages, and newsletter signups. The underlying database is created automatically when your site uses a feature that needs server-side storage (forms, newsletter signups, an authentication integration, etc.).

The Database panel is available on Pro plans and above, and only appears for projects that have server-side features enabled.

Accessing the Database

1. Open your project in the AI Editor
2. Go to Workspace → Database

Viewing Your Data

Tables List

The main view shows all data tables in your site:

• Table name - The type of data (e.g., Contacts, Subscribers)
• Row count - How many entries are in each table
• Icon - Visual indicator of the data type

Browsing Entries

Click on any table to view its contents:

• Paginated view - 20 entries per page
• All columns - See all collected fields
• Navigation - Use Previous/Next to browse pages

Common Data Types

Tables are created by the integrations and features your site uses. Common ones:

Blog posts and documentation pages are not stored here — they live as MDX files in src/content/ and are part of your code, not your database.

Managing Data

Deleting Entries

To remove an entry:

1. Click on the table containing the entry
2. Find the row you want to delete
3. Click the delete button
4. Confirm the deletion

Refreshing Data

Click the refresh button to load the latest data from your site.

Data Formatting

The database viewer automatically formats data for readability:

• Dates - Displayed in your local timezone
• Yes/No values - Shown as “Yes” or “No” instead of true/false
• Long text - Truncated with option to view full content
• JSON data - Pretty-printed for easy reading

Exporting Data

Currently, data can be viewed within PageSmith. For advanced data management, consider connecting your forms to external services like:

• Google Sheets
• Airtable
• Your own database via webhooks