Database Connectors
Connect your data sources to WorkFlows. Once connected, the AI engine has full context of your schema and data to answer questions in natural language.
Setup via Dashboard
The easiest way to add a connector is through the Dashboard:
- Go to Dashboard → Data
- Click Add Connection
- Select your database type and fill in the connection details
- Click Test Connection to verify
- Save. WorkFlows will read your schema automatically.
PostgreSQL
AvailableConnect to any PostgreSQL 12+ database. WorkFlows reads your schema and uses it as context for AI queries.
Connection fields
| Field | Example | Required |
|---|---|---|
| Host | db.example.com | Required |
| Port | 5432 | Required |
| Database | analytics | Required |
| Username | workflows_reader | Required |
| Password | •••••••• | Required |
| SSL | Enabled (recommended) | Optional |
Connection string format
postgresql://workflows_reader:password@db.example.com:5432/analytics?sslmode=requireCreate via API
curl -X POST https://www.workflows.com.es/api/v1/connections \
-H "Authorization: Bearer wf_live_your_key" \
-H "Content-Type: application/json" \
-d '{
"name": "Production Analytics DB",
"dbType": "postgresql",
"host": "db.example.com",
"port": 5432,
"database": "analytics",
"username": "workflows_reader",
"password": "your_password",
"ssl": true
}'MySQL
AvailableConnect to MySQL 8.0+ or MariaDB 10.5+ databases. Same AI-powered querying capabilities as PostgreSQL.
Connection fields
| Field | Example | Required |
|---|---|---|
| Host | mysql.example.com | Required |
| Port | 3306 | Required |
| Database | operations | Required |
| Username | workflows_reader | Required |
| Password | •••••••• | Required |
| SSL | Enabled (recommended) | Optional |
Connection string format
mysql://workflows_reader:password@mysql.example.com:3306/operationsCreate via API
curl -X POST https://www.workflows.com.es/api/v1/connections \
-H "Authorization: Bearer wf_live_your_key" \
-H "Content-Type: application/json" \
-d '{
"name": "Operations MySQL",
"dbType": "mysql",
"host": "mysql.example.com",
"port": 3306,
"database": "operations",
"username": "workflows_reader",
"password": "your_password",
"ssl": true
}'REST API
AvailableConnect external REST APIs as data sources. WorkFlows can query your API endpoints and use the responses as context for AI analysis.
Connection fields
| Field | Example | Required |
|---|---|---|
| Base URL | https://api.example.com/v1 | Required |
| Auth Header | Authorization: Bearer token | Optional |
| Name | CRM API | Required |
Create via API
curl -X POST https://www.workflows.com.es/api/v1/connections \
-H "Authorization: Bearer wf_live_your_key" \
-H "Content-Type: application/json" \
-d '{
"name": "CRM API",
"dbType": "rest_api",
"host": "https://api.example.com/v1",
"headers": {
"Authorization": "Bearer your_api_token"
}
}'Security
- All credentials are encrypted at rest with AES-256-GCM
- Connections are tested server-side; credentials never leave the backend
- We recommend creating read-only database users for WorkFlows
- SSL/TLS is supported and recommended for all database connections
Coming Soon
MongoDB
NoSQL document database support
Snowflake
Cloud data warehouse
BigQuery
Google Cloud analytics data warehouse
Redshift
Amazon cloud data warehouse
CSV / Excel upload
You can also upload CSV and Excel files directly from the Dashboard. Go to Dashboard → Dataand drag & drop your files. WorkFlows will parse and index them for AI queries.