Manage your GibsonAI database with Drizzle Studio

Introduction

Access your Gibson AI cloud database directly through local SQL editors like Drizzle Studio for viewing and modifying database content.

Setting Up the Connection

1. Clone the repository from GitHub:

2. Install dependencies:

3. Configure database connection:

   • Copy your connection string from Gibson AI project settings

   • Create an .env file in the root directory

   • Add your connection string with SSL settings:

Launching Drizzle Studio

1. Start the studio interface:

2. Open the interface in your browser (URL will appear in terminal)

Working with Your Database

1. Browse tables - All tables from your Gibson database appear in the left panel

2. Insert records - Add new data by clicking "Add Record" for any table

3. Run SQL queries - Use the SQL Runner to execute custom queries:

   SELECT * FROM

4. View table structure - Click the "Structure" button to examine schema details

Important Notes

• Changes are live - Any modifications made in Drizzle Studio affect your production database

• Use caution when making changes to avoid unintended data loss

• Same connection string works with other tools like Beekeeper Studio

This connection method provides direct access to your Gibson AI database for advanced data management and exploration.