AI Notebook Lab

AI-powered notebook environment built on JupyterLab for data science, analysis, and development.

Overview

AI Notebook Lab is built on JupyterLab, the industry-standard notebook environment, enhanced with deeply integrated AI capabilities. Query databases with natural language, generate visualizations, learn from your codebase, and leverage multiple AI providers—all within your notebooks.

Key Capabilities

Calliope AI (%calliope / %%calliope)

The primary AI interface for database operations and smart assistance:

• Natural Language SQL - Ask questions, get SQL + results + charts
• RAG Training - Teach AI your business logic and schema
• Multi-Database Support - PostgreSQL, MySQL, SQLite, and more
• Smart Visualizations - Automatic chart generation

Advanced AI (%ai / %%ai)

Direct access to AI models for code generation, explanations, and more:

• Multiple Providers - OpenAI, Anthropic, Google, Mistral, Ollama
• Output Formats - Code, markdown, HTML, math, JSON, images
• Variable Interpolation - Reference notebook variables in prompts
• Conversation Memory - Multi-turn context across cells

Chat Interface

Sidebar chat with slash commands:

• /learn - Index local files for Q&A
• /generate - Create entire notebooks from descriptions
• /fix - Diagnose and fix code errors
• /ask - Query learned content
• /clear - Reset conversation

Quick Start

Natural Language SQL

%%calliope ask-sql sales_db
What were the top 10 products by revenue last quarter?

Output includes:

• Generated SQL query
• Executed results as a table
• Automatic visualization (if applicable)
• Suggested follow-up questions

Code Generation

%%ai claude -f code
Write a function to calculate compound interest with
principal, rate, time, and compounding frequency parameters

Learn Your Codebase

# In chat sidebar
/learn ./src

# Then ask questions
/ask How does the authentication system work?

Example Notebooks

Explore the Calliope Demo Repository with 28 ready-to-run notebooks:

By Database

By Topic

• Calliope-GettingStarted.ipynb - First queries, model selection
• Calliope-AdvancedQueries.ipynb - Joins, window functions, analytics
• Calliope-Visualizations.ipynb - Charts, plots, dashboards
• Calliope-RAGTraining.ipynb - Schema training, business logic
• Calliope-DirectSQL.ipynb - SQL generation and debugging
• Calliope-JupyterAI-Integration.ipynb - Multi-model workflows

When to Use Lab

Documentation