---

name: database-access description: TinyBots database connection info, schema queries, and context gathering commands for MySQL databases

TinyBots Database Access

When working on tasks requiring database context (schema changes, queries, migrations), use this guide to query databases directly.

Database Connection Info

The project uses MySQL databases running via Docker Compose (devtools/tinybots/local/docker-compose.yaml):

Quick Start

Step 1: Ensure Docker Services Are Running

Copycd devtools/tinybots/local && docker compose ps

If not running, start them:

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

Step 2: Connect to Databases (Interactive)

Copy# 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)

Copy# 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

Copy-- 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