Data Sources
Connect your databases and data warehouses to FreshGuard.
A data source is a connection to one of your databases. FreshGuard uses this connection to run monitoring checks against your tables.
Supported Databases
| Database | Minimum Tier | Guide |
|---|---|---|
| BigQuery | Free+ | Connect |
| DuckDB | Free+ | — |
| MySQL | Starter+ | Connect |
| Snowflake | Starter+ | Connect |
| SQL Server | Starter+ | Connect |
| Azure SQL | Starter+ | Connect |
| PostgreSQL | Professional+ | Connect |
| Redshift | Professional+ | Connect |
| Synapse Analytics | Professional+ | Connect |
Adding a Source
- Go to Sources in the sidebar.
- Click Add Source.
- Select your database type.
- Fill in the connection details (host, port, database, credentials).
- Click Test Connection to verify connectivity.
- Save.
After saving, FreshGuard will fetch the list of available tables from your database. These tables will appear when you create rules.
Testing Connections
The Test Connection button performs a lightweight connectivity check: it connects, runs a simple query (e.g. SELECT 1), and verifies that your credentials have read access. If the test fails, you’ll see a specific error message indicating the problem (e.g. authentication failure, network timeout, SSL mismatch).
Managing Sources
From the sources list you can:
- Edit — Update connection details or credentials.
- Delete — Remove a source and all associated rules. This action cannot be undone.
- View tables — See the tables FreshGuard has discovered on this source.
Source Limits
The number of sources you can add depends on your plan:
| Plan | Max Sources |
|---|---|
| Free | 1 |
| Starter | 3 |
| Professional | 10 |
| Enterprise | Unlimited |
Credential Security
Encryption at rest
All database credentials are encrypted using AES-256-GCM before being stored. FreshGuard never logs or displays plaintext passwords after initial entry.
We strongly recommend connecting with a dedicated read-only database account that has the minimum required permissions. See the Database Guides for step-by-step instructions on creating secure accounts for each supported database.