Schema Updates and Migrations

Manage database schema changes with GibsonAI's automatic zero-downtime migration capabilities. GibsonAI handles all the complexity of migrations and versioning on the backend, so you can evolve your data model in production without interruptions or manual migration scripts.

How it works

GibsonAI automatically handles complex migrations and versioning on the backend with no extra work from the developer. Simply describe your schema changes in natural language, and GibsonAI manages all the migration complexity behind the scenes, ensuring zero downtime and safe deployments.

Key Features

Automatic Migration Management

• Zero-Downtime Migrations: All schema changes are deployed without service interruptions
• Backend Complexity Handling: GibsonAI manages migration scripts, rollbacks, and versioning automatically
• Natural Language Changes: Describe your schema modifications in plain English
• Safe Deployments: Automatic validation and safety checks for all schema changes

Text-to-SQL Analysis

• Data Exploration: Ask questions about your data in natural language
• Automatic SQL Generation: GibsonAI generates the SQL queries to answer your questions
• Gibson Studio Integration: Run generated queries in the intuitive data management UI
• Real-time Insights: Get immediate answers about your data without writing SQL

Step-by-step guide

1. Make schema changes with natural language

gibson modify users "Add a profile_picture_url column and an is_verified boolean field"

GibsonAI automatically:

• Generates the migration script
• Validates the changes
• Deploys with zero downtime
• Updates your Pydantic schemas and SQLAlchemy models

2. Explore your data with text-to-SQL

Use Gibson Studio to ask questions about your data:

• "Show me all users who joined in the last 30 days"
• "What's the average order value by customer segment?"
• "Find duplicate email addresses in the users table"

GibsonAI generates and runs the SQL automatically.

3. Access your data via APIs

Integration options:

• OpenAPI Spec: Available 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: Available in the data API section of the UI

Use cases

• Schema versioning and deployment

  Manage schema evolution across development and production environments with automatic versioning

• AI-driven schema generation

  Generate database schemas and Pydantic models with natural language prompts

• Unified API layer

  Create consistent data access patterns with automatically generated RESTful APIs

What's next?