Skip to main content
ToeBox integrates with data warehouses so you can build analytics dashboards and give your agents access to business data beyond what Shopify provides natively.

​
Supported warehouses

WarehouseConnection TypeStatus
SnowflakeConnection stringAvailable
PostgreSQLConnection stringAvailable

​
Snowflake setup

1

Create a read-only user (recommended)

In your Snowflake account, create a dedicated user for ToeBox:
CREATE USER toebox_reader PASSWORD = 'your-secure-password';
CREATE ROLE toebox_role;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE toebox_role;
GRANT USAGE ON DATABASE your_database TO ROLE toebox_role;
GRANT USAGE ON SCHEMA your_database.public TO ROLE toebox_role;
GRANT SELECT ON ALL TABLES IN SCHEMA your_database.public TO ROLE toebox_role;
GRANT ROLE toebox_role TO USER toebox_reader;
2

Add the integration in ToeBox

Navigate to Integrations and click Connect on the Snowflake card. Fill in:
  • Account — Your Snowflake account ID (e.g., xy12345.us-east-1)
  • Username — toebox_reader
  • Password — The password you set
  • Warehouse — COMPUTE_WH (or your preferred warehouse)
  • Database — The database name
  • Schema — The default schema (typically PUBLIC)
3

Test the connection

Click Test Connection. ToeBox will attempt to connect and list available tables. If successful, click Save.

​
PostgreSQL setup

1

Create a read-only user (recommended)

CREATE USER toebox_reader WITH PASSWORD 'your-secure-password';
GRANT CONNECT ON DATABASE your_database TO toebox_reader;
GRANT USAGE ON SCHEMA public TO toebox_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO toebox_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT ON TABLES TO toebox_reader;
2

Add the integration in ToeBox

Navigate to Integrations and click Connect on the PostgreSQL card. Fill in:
  • Host — Your database host
  • Port — Default is 5432
  • Database — The database name
  • Username — toebox_reader
  • Password — The password you set
  • SSL — Enable if required by your database provider
3

Test the connection

Click Test Connection to verify. If successful, click Save.
Always use a read-only database user. While ToeBox only executes SELECT queries, a read-only user provides defense in depth against accidental data modification.

​
Schema browser

Once a data warehouse is connected, ToeBox provides a schema browser in the Analytics page:
  • Browse all tables in your database
  • View column names and data types
  • Preview sample data
  • Copy table and column names into your SQL queries
The schema browser is also used by the AI Assistant to understand your database structure when generating SQL queries.

​
Security considerations

  • Credentials are encrypted at rest in ToeBox’s database
  • Network access — Ensure your database allows connections from ToeBox’s IP addresses. Contact support@toebox.ai for the current IP allowlist.
  • Read-only access — ToeBox enforces read-only queries at the application level, but using a read-only database user adds an additional safety layer
  • No data storage — Query results are streamed to your browser and are not stored on ToeBox servers