Data Connectors Overview
Connect MySQL, PostgreSQL, BigQuery, Snowflake, MSSQL, Google Analytics, and Search Console to Formula Bot for real-time data analysis.
Data Connectors allow you to query your databases and analytics platforms directly from Formula Bot. Instead of exporting data manually, connect once and analyze in real-time.
Available Connectors
Analytics Platforms
- Google Analytics - GA4 website and app analytics
- Google Search Console - Search performance data
Databases
- MySQL - Open-source relational database
- PostgreSQL - Advanced open-source database
- MSSQL - Microsoft SQL Server
Data Warehouses
Benefits of Connectors
Real-Time Data
- No more exporting and uploading files
- Always analyze the latest data
- Changes in your source are immediately available
Secure Access
- Credentials stored encrypted
- Read-only access by default
- No data copied to Formula Bot servers
Smart Context
- Formula Bot understands your database schema
- Automatic column type detection
- Relationship awareness for joins
How Connectors Work
- Connect - Authenticate with your data source
- Configure - Select tables and set access controls
- Query - Ask questions in natural language
- Analyze - Get insights without writing SQL
Formula Bot translates your questions into appropriate queries and returns the results.
You don't need to know SQL. Formula Bot writes the queries for you based on your natural language questions.
Setting Up a Connector
- Go to Connectors in the sidebar
- Click Add Connector
- Select your data source type
- Follow the connection wizard
- Test the connection
Each connector has specific setup requirements. See the individual guides for details.
Managing Connectors
View Connection Status
Check if your connectors are active and functioning:
- Green = Connected and working
- Yellow = Token expiring soon
- Red = Connection failed
Edit Configuration
Update connection settings:
- Change credentials
- Modify table access
- Update knowledge base settings
Delete Connector
Remove a connection when no longer needed. This doesn't affect your source data.
Advanced Features
Knowledge Base
For SQL databases, enable Knowledge Base to:
- Index your table structures
- Improve query accuracy
- Get better natural language understanding
Data Access Controls
Restrict what the AI can see:
- Row-level filtering
- Column exclusions
- Table restrictions
Use Data Access Controls when connecting to databases with sensitive information you don't want included in analysis.
Connector Limits
| Plan | Connectors |
|---|---|
| Free | 1 |
| Starter | 3 |
| Pro | 10 |
| Max | Unlimited |
Next Steps
Choose your data source to get started: