Normal User ๐Ÿ‘ค default

Everything a researcher needs โ€” upload data, chat with AI, build visualizations, and run repeatable analysis recipes.

Getting Started

  1. Register an account โ€” Create your account at /register. You'll need to verify your email address before logging in. During registration you can set your preferred language and other preferences.

  2. Configure connections โ€” Head to Settings โ†’ Database Connections to save your PostgreSQL or MySQL credentials. Then go to Settings โ†’ AI Connections to point the Workbench to an AI provider (local Ollama or a remote OpenAI-compatible service).

  3. Upload or connect data โ€” Upload CSV/Excel files under Tools โ†’ Upload CSV/Excel, or connect directly to database tables under Tools โ†’ Connect Database.

  4. Start analysing โ€” Chat with the AI assistant, build visualizations, or create a repeatable recipe.

Tip: You need at least one database connection and one AI connection configured before the AI-powered features will work. The Workbench connects these together so the AI can read your database schemas and data.

AI Chat & Assistants

๐Ÿ’ฌ General AI Chat

Ask questions, get coding help, or brainstorm analysis approaches. Supports audio speech input and output. Manage multiple conversations and switch between them. Copy responses with one click.

  • Multi-turn conversations with AI models
  • Select any configured AI provider and model
  • Audio speech input/output for hands-free interaction
  • Copy individual messages to clipboard

๐Ÿ—„๏ธ AI Database Design

Connect a database and let the AI inspect its schema โ€” tables, columns, foreign keys, and indexes. The AI will flag structural issues (missing indexes, data type concerns, normalization problems) and suggest improvements.

  • Inspect schema: tables, columns, FKs, indexes
  • AI-generated structural analysis with severity ratings
  • Category-tagged recommendations (performance, integrity, etc.)
  • Conversational follow-up on each finding

๐Ÿงน AI Dataset Cleaning

Select a dataset and the AI will review column schemas โ€” types, null counts, unique counts, and sample values โ€” then suggest cleaning steps (handling missing values, fixing data types, normalizing text).

  • Column schema overview with statistics
  • AI-generated cleaning suggestions
  • Review sample values before taking action
  • Apply cleaning rules to your data

๐Ÿ“Š AI Analysis Rules

Tell the AI what you want to learn from your dataset and it will propose analysis rules โ€” statistical tests, aggregations, groupings โ€” that you can incorporate into a recipe.

  • Generate analysis approaches from natural language
  • Rules you can preview before applying
  • Save as repeatable recipes for future runs

Datasets & Data Management

๐Ÿ“ค Upload CSV & Excel

Drag-and-drop CSV or Excel files. Configure delimiter, quote character, and encoding. Preview data before importing. The Workbench stores uploaded data in DuckDB for fast local analysis.

๐Ÿ”— Connect Databases

Browse tables and views from your configured PostgreSQL or MySQL connections. Select specific columns to pull in. Define them as datasets for analysis. Your database credentials are stored per-user and never shared.

๐Ÿ“‹ Dataset Browser

Search and filter all your datasets by source type (upload, table, view, virtual) and group visibility. View metadata, browse data snapshots, and manage column definitions. Trigger data preparation rules from here.

๐Ÿ““ Jupyter Notebook Import

Upload .ipynb files. The Workbench extracts DataFrame definitions, shows column info and row counts, and imports the resulting tables into your database. Great for bringing in analysis work from external tools.

Visualization & Recipes

๐Ÿ“ˆ Data Visualizations

Create interactive Plotly charts โ€” bar, scatter, line, pie, histogram, and more. Choose a visualization type, provide data as JSON or CSV, configure parameters, and render. Export charts as images for reports.

๐Ÿ“‹ Analysis Recipes

Build repeatable analysis workflows. A recipe bundles data preparation rules and analysis steps. Select a dataset, configure input columns, set filter conditions, add custom parameters, then reorder steps via drag-and-drop. Run the recipe now or save it for later โ€” and get the same results every time on updated data.

๐Ÿ“œ Recipe History

Track every execution of your recipes. See when they ran, on which dataset, and review the results. Compare runs over time as your data changes.

Your Profile & Settings

๐Ÿ‘ค Profile

  • Update your name and email
  • Change your password
  • Choose your preferred interface language (9 languages available)
  • Toggle dark mode
  • Subscribe to BCC registration emails
  • View your group memberships and role badges

๐Ÿ—„๏ธ Database Connections

  • Add PostgreSQL or MySQL connections
  • Test connections to verify they work
  • Edit or delete saved connections
  • Assign connections to groups for shared access
  • Set read/write permissions per connection

๐Ÿค– AI Connections

  • Add AI providers (Ollama, OpenAI-compatible)
  • Configure endpoints, API keys, and models
  • Test connections to verify they work
  • Assign connections to groups

What Normal Users Cannot Do

As a normal user you cannot: