Skip to main content
Ana comes equipped with several powerful tools that can be configured for each chat. These tools enable Ana to access different capabilities and data sources depending on your needs.
Getting Started: When creating a new chat, you’ll see a tools menu where you can enable or disable specific capabilities. Only enable what you need for optimal performance.

​
Core Analysis Tools

These are Ana’s primary tools for retrieving and analyzing data.

Text to SQL

Convert natural language questions into SQL queries and fetch data from your data warehouses.

Python

Execute Python code to analyze, visualize, and process data with a comprehensive set of data science libraries.

Web Search

Search the web for current information, market trends, and external context powered by Exa.

​
Semantic Layer Tools

Build and query using your organization’s business definitions.

Ontology

Query data using your pre-configured semantic layer with consistent business metrics and definitions.

Ontology Editing

Allow Ana to modify and build your ontology directly during conversations.

​
Workflow Tools

Automate recurring analyses and reports.

Playbooks

Create and manage automated workflows that run on schedules or events. Perfect for daily reports, weekly summaries, and event-driven alerts.

​
Extension Tools

Connect Ana to external services and custom integrations.

MCP (Model Context Protocol)

Extend Ana’s capabilities with custom tools and external service integrations like Notion, GitHub, Slack, and more.

​
Connectors

In addition to the tools above, you can select which data sources Ana should use for a particular chat.
Multiple connector selection: You can select multiple connectors for a single chat, allowing Ana to query across different data sources.
  • Supabase - Connect to Supabase
  • ClickHouse - Connect to ClickHouse
  • Postgres - Connect to Postgres
  • Redshift - Amazon Redshift data warehouse
  • Snowflake - Access your Snowflake cloud data platform
  • BigQuery - Query data from Google BigQuery
  • Azure Synapse Analytics - Microsoft Azure Synapse Analytics
  • Amazon Aurora MySQL - Connect to Amazon Aurora MySQL
  • Databricks - Connect to Databricks
  • Motherduck - Connect to Motherduck
  • MySQL - Connect to MySQL
  • Athena - Connect to AWS Athena
  • Tableau - Connect to Tableau Server
  • Power BI - Connect to Microsoft PowerBI
  • File uploads - CSV, Excel, and other data files
  • MCP servers - Custom data sources via Model Context Protocol
Learn how to add and manage connectors on the Connectors Page.

​
Configuration Tips

1

Start Minimal

Only enable the tools you need for each chat to improve performance and reduce costs. You can always create a new chat with different tools enabled.
2

Combine Tools Strategically

  • Web Search + Text to SQL: Enrich warehouse data with external context
  • Python + Text to SQL: Advanced analysis and visualization
  • Ontology + Python: Consistent metrics with custom visualizations
3

Use Ontology for Consistency

If you have an ontology configured, enable it before starting analysis for more accurate and consistent results.
4

Extend with MCP

Use MCP servers to connect Ana to your organization’s specific tools and services like Notion, GitHub, or internal APIs.
Changing Settings Mid-Chat: Once you initialize a chat session, you cannot change tool settings mid-conversation. To use different tools, you’ll need to create a new chat instance.