Database
Frontend allows you to connect to a cloud database solution powered by PostgreSQL with Neon. Once connected, you can interact with your database directly through the AI chat or use the Database viewer to manage your data.
Connecting Your Database
Section titled “Connecting Your Database”When you connect a database to your project, Frontend automatically provisions a Neon PostgreSQL database for you. Once connected, the Frontend AI will be able to perform actions on your database like creating new tables or querying your data.
Working with Your Database
Section titled “Working with Your Database”After connecting your database, you have two ways to interact with it:
AI Chat
Section titled “AI Chat”You can run queries and execute commands directly from the AI chat. Simply describe what you want to do with your data, and the AI will generate and execute the appropriate SQL queries. For example:
- “Create a table for storing user contacts”
- “Insert a new user into the users table”
- “Show me all orders from the last 30 days”
- “Update the status of order #123 to shipped”
Database Viewer
Section titled “Database Viewer”Use the Database viewer to visually manage your data. The viewer allows you to:
- Browse tables and view their structure
- View, add, edit, and delete records
- Execute custom SQL queries
- Export data as needed
Use Cases
Section titled “Use Cases”A database opens up many possibilities for your applications:
- Storing contacts - Build contact forms that save submissions to your database
- User data - Store user profiles, preferences, and account information
- Stripe e-commerce - Track products, orders, customers, and inventory alongside your Stripe integration
- Authentication solutions - Store user credentials, sessions, and access tokens for custom auth systems
- Content management - Store blog posts, articles, and media references
- Complex applications - Build full-featured applications with persistent data storage