Database
View and manage data collected from your website forms and interactions.
The Database panel in your Workspace shows data collected from your website, such as form submissions, contact messages, and newsletter signups.
Accessing the Database
- Open your project in the AI Editor
- 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
| Table | Description |
|---|---|
| Contacts | Messages from contact forms |
| Subscribers | Newsletter signups |
| Users | User registrations |
| Posts | Blog or content entries |
Managing Data
Deleting Entries
To remove an entry:
- Click on the table containing the entry
- Find the row you want to delete
- Click the delete button
- 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
Availability
The Database panel is available on paid plans and when your site has server-side features enabled.
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