Database Access

vly.ai provides direct access to your Convex database through an intuitive interface, allowing you to view, query, and manage data in both development and production environments.

Database environments

Development environment

Purpose: Testing, iteration, and experimentation

• Isolated data separate from production
• Safe for testing new features and schema changes
• Real-time updates during development
• Full CRUD operations available
• Schema modifications allowed

Production environment

Purpose: Live application data

• Live user data from deployed application
• Read-only by default for safety
• Backup and recovery systems in place
• Performance monitoring enabled
• Schema changes require careful migration

Environment switching

Switch between environments through the Database tab to access development or production data as needed.

Database interface

Table browser

Navigate your database schema:

• Table list showing all collections
• Document count for each table
• Schema preview with field types
• Real-time updates as data changes

Document viewer

Inspect individual records with all field values and metadata displayed in an easy-to-read format.

Query interface

Execute queries directly:

• Visual query builder for common operations
• Query history to reuse previous searches
• Result export in JSON or CSV format

Data operations

Development environment operations

• Create documents: Add new records with data validation
• Update documents: Modify existing records with automatic timestamps
• Delete documents: Remove records safely with confirmation prompts
• Query documents: Search and filter data using various criteria

Production environment operations

• Read operations: View all data in read-only mode
• Write operations (restricted): Contact support for production data modifications

Schema management

Schema visualization

View your database structure with table definitions, field types, relationships, and indexes clearly displayed.

Schema modifications

Development environment:

• Add new tables and fields freely
• Modify existing fields with automatic migration
• Test schema changes before production

Production environment:

• Plan migrations carefully to avoid data loss
• Contact support for complex schema changes
• Backup data before structural modifications

Environment variables

Store sensitive configuration securely with separate settings for development and production environments, including secure storage with encryption and access controls based on user roles.

Database monitoring

Track database health with query performance metrics, document counts, storage usage, and real-time updates showing live changes and activity logs.

Security and access control

Access permissions

Database access follows project permissions:

Owners:

• Full access to both environments
• Schema modification rights
• Environment variable management

Editors:

• Read/write access to development
• Read-only access to production
• Limited schema modification rights

Viewers:

• Read-only access to development only
• Export capabilities only

Security best practices

• Use development environment for testing
• Backup production data before changes
• Limit production access to necessary personnel
• Use environment variables for sensitive data

The database access system provides the tools you need to understand, monitor, and manage your application data while maintaining security and preventing accidental data loss.