ContextFlo

Supported Databases

Complete list of supported data sources and their features

Last updated: 1/17/2025

ContextFlo supports a wide range of databases and data warehouses.

Relational Databases

PostgreSQL

Status: ✅ Fully Supported

Versions: 10, 11, 12, 13, 14, 15, 16

Features:

  • Connection pooling
  • SSL/TLS encryption
  • Read replicas
  • Custom schemas

Default Port: 5432

Hosting Options:

  • Self-hosted
  • AWS RDS
  • Google Cloud SQL
  • Azure Database
  • Heroku
  • Supabase

MySQL

Status: ✅ Fully Supported

Versions: 5.7, 8.0+

Features:

  • SSL connections
  • Multiple databases
  • Character set support

Default Port: 3306

Hosting Options:

  • Self-hosted
  • AWS RDS
  • Google Cloud SQL
  • Azure Database
  • PlanetScale

Cloud Data Warehouses

Snowflake

Status: ✅ Fully Supported

Features:

  • Multi-cloud support (AWS, Azure, GCP)
  • Virtual warehouse selection
  • Role-based access
  • Query result caching

Connection Requirements:

  • Account identifier
  • Warehouse name
  • Database and schema
  • Username and password

Amazon Redshift

Status: ✅ Fully Supported

Features:

  • Cluster endpoint connection
  • SSL encryption
  • IAM authentication (coming soon)
  • Spectrum support

Default Port: 5439

Google BigQuery

Status: ✅ Fully Supported

Features:

  • Service account authentication
  • Multiple projects
  • Dataset selection
  • Cost estimation

Authentication:

  • Service account JSON key required
  • OAuth 2.0 (coming soon)

NoSQL Databases

Amazon DynamoDB

Status: ✅ Supported (Limited)

Features:

  • Table scanning
  • Query operations
  • GSI/LSI support

Authentication:

  • AWS Access Key ID
  • AWS Secret Access Key
  • Region selection

Note: DynamoDB queries are different from SQL. Use PartiQL syntax.

Coming Soon

ClickHouse

Status: 🚧 In Development

ETA: Q2 2025

Features:

  • OLAP analytics
  • Real-time queries
  • Column-oriented storage

MongoDB

Status: 🚧 Planned

ETA: Q3 2025

Features:

  • Aggregation pipelines
  • Document queries
  • Atlas support

Databricks

Status: 🚧 Planned

ETA: Q3 2025

Features:

  • Delta Lake support
  • Spark SQL
  • Unity Catalog

Feature Comparison

| Database | SSL/TLS | Connection Pool | Read Replicas | Custom Port | |----------|---------|-----------------|---------------|-------------| | PostgreSQL | ✅ | ✅ | ✅ | ✅ | | MySQL | ✅ | ✅ | ✅ | ✅ | | Snowflake | ✅ | ✅ | N/A | N/A | | Redshift | ✅ | ✅ | ✅ | ✅ | | BigQuery | ✅ | ✅ | N/A | N/A | | DynamoDB | ✅ | ✅ | N/A | N/A |

Request a Database

Don't see your database? Let us know!

Most requested:

  1. MongoDB
  2. ClickHouse
  3. Cassandra
  4. Elasticsearch

How to request:

  • Email: support@contextflo.com
  • In-app feedback: Click "Request Feature"
  • Community forum: forum.contextflo.com

Database-Specific Notes

PostgreSQL

Best Practices:

  • Use read replicas for analytics
  • Create indexes on frequently queried columns
  • Use EXPLAIN ANALYZE to optimize queries

Extensions Supported:

  • PostGIS (geospatial data)
  • pg_trgm (full-text search)
  • uuid-ossp (UUID generation)

Snowflake

Cost Optimization:

  • Use smaller warehouses for dashboards
  • Enable auto-suspend
  • Set statement timeout limits

Performance:

  • Results are cached for 24 hours
  • Use clustering keys for large tables
  • Leverage materialized views

BigQuery

Cost Control:

  • Queries show estimated cost before running
  • Use partitioned tables
  • Avoid SELECT *

Limits:

  • 10GB per query (default)
  • Concurrent queries vary by project

DynamoDB

Query Patterns:

  • Prefer Query over Scan
  • Use indexes for efficient access
  • Limit result sets to reduce costs

Security & Compliance

Data Residency

  • Your data never leaves your database
  • ContextFlo only reads data on-demand
  • No data is stored permanently (except metadata)

Compliance

  • SOC 2 Type II (in progress)
  • GDPR compliant
  • HIPAA-ready architecture

Encryption

  • All connections use SSL/TLS
  • Credentials encrypted at rest (AES-256)
  • Encryption in transit

Next Steps