Schema versioning and deployment

Manage database schema evolution with GibsonAI's automatic versioning across development and production environments. GibsonAI handles all versioning complexity on the backend, enabling safe schema changes and zero-downtime deployments with automatic migration management.

How it works

GibsonAI automatically handles complex migrations and versioning on the backend with no extra work from the developer. The system manages separate development and production environments, automatically tracking schema changes and enabling safe deployments with built-in rollback capabilities.

• Automatic versioning

  Backend versioning system tracks all schema changes automatically

• Safe deployments

  Zero-downtime deployments with automatic validation and rollback

• Environment management

  Seamless synchronization between development and production environments

• Model generation

  Automatic Pydantic schemas and SQLAlchemy models with every change

Key Features

Automatic Backend Versioning

• Seamless Version Control: All schema changes are automatically versioned
• Migration Management: Complex migrations handled entirely by GibsonAI
• Rollback Capabilities: Safe rollback to previous schema versions
• Change Tracking: Complete audit trail of all schema modifications

Multi-Environment Support

• Development Environment: Safe testing ground for schema changes
• Production Environment: Zero-downtime deployments to production
• Environment Synchronization: Automatic promotion from development to production
• Isolation: Complete separation between environments

Data Exploration and Analysis

• Text-to-SQL: Ask questions about your data in natural language
• Gibson Studio: Intuitive data management UI for running queries
• Automatic SQL Generation: GibsonAI generates SQL to answer your questions
• Real-time Insights: Immediate data analysis without writing SQL

Step-by-step guide

1. Test changes in development

# Working in development environment
# Make schema changes using natural language
gibson modify products "Add a category_id foreign key and remove the old category_name column"

GibsonAI automatically:

• Generates the migration script
• Updates Pydantic schemas and SQLAlchemy models
• Deploys to development environment
• Validates the changes

2. Explore your data with text-to-SQL

Use Gibson Studio to validate your changes:

• "Show me all products with their new category relationships"
• "Find any products that might have lost category data"
• "What's the distribution of products across categories?"

3. Deploy to production

# Working in production environment
# Deploy the validated changes
gibson deploy

GibsonAI handles:

• Zero-downtime migration
• Automatic rollback if issues occur
• API endpoint updates
• Model regeneration

4. Access your updated data

Integration options:

• OpenAPI Spec: Updated automatically in your project settings
• Direct Connection: Connection string available in the UI
• RESTful APIs: Base URL https://api.gibsonai.com
  • SQL queries: /v1/-/query
  • Table operations: /v1/-/[table-name-in-kebab-case]
• API Documentation: Always up-to-date in the data API section

Use cases

• Schema updates and migrations

  Manage schema changes with automatic zero-downtime migrations

• AI-driven schema generation

  Generate schemas and Pydantic models with natural language

• Unified API layer

  Consistent data access with automatically generated APIs

What's next?