Database Access

Step 1: Ensure Docker Services Are Running

cd devtools/tinybots/local && docker compose ps

If not running, start them:

cd devtools/tinybots/local && docker compose up -d mysql-typ-e-db mysql-wonkers-db

Step 2: Connect to Databases (Interactive)

# typ-e-db (tinybots database)
docker exec -it mysql-typ-e-db mysql -u root -pICgVcbpYW731vY3UjexgAnuQ69Wv2DdN tinybots

# wonkers-db (dashboard database)
docker exec -it mysql-wonkers-db mysql -u root -pICgVcbpYW731vY3UjexgAnuQ69Wv2DdN dashboard

One-Liner Commands (Non-Interactive)

# List all tables in typ-e-db
docker exec mysql-typ-e-db mysql -u root -pICgVcbpYW731vY3UjexgAnuQ69Wv2DdN tinybots -e "SHOW TABLES;"

# Describe a specific table
docker exec mysql-typ-e-db mysql -u root -pICgVcbpYW731vY3UjexgAnuQ69Wv2DdN tinybots -e "DESCRIBE users;"

# Get full CREATE TABLE statement
docker exec mysql-typ-e-db mysql -u root -pICgVcbpYW731vY3UjexgAnuQ69Wv2DdN tinybots -e "SHOW CREATE TABLE users\G"

# List all tables in wonkers-db
docker exec mysql-wonkers-db mysql -u root -pICgVcbpYW731vY3UjexgAnuQ69Wv2DdN dashboard -e "SHOW TABLES;"

Common Queries for Context Gathering

-- List all tables
SHOW TABLES;

-- Describe table structure
DESCRIBE table_name;

-- Get full CREATE TABLE statement
SHOW CREATE TABLE table_name;

-- Get detailed column info
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'tinybots' AND TABLE_NAME = 'your_table';

-- Find tables by pattern
SHOW TABLES LIKE '%pattern%';

-- List all foreign key relationships
SELECT
    TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME,
    REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_NAME IS NOT NULL
  AND TABLE_SCHEMA = 'tinybots';

Database Ownership