Database Configuration

cloudquery currently supports two types of databases: Relational - SQLite, MySQL, PostgreSQL, SQL Server and graph - Neo4j.
Relational
SQLite
MySQL
PostgreSQL
SQL Server
SQLite
This is the default behaviour that uses a local sqlite file as database. Works great for development and local testing.
./cloudquery fetch # you can change the default sqlite.db file via --dsn
MySQL
./cloudquery fetch --driver mysql --dsn "root:[email protected](127.0.0.1:3306)/dbname"
To run a local MySQL instance via docker:
docker run -p 3306:3306 -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=dbname -d mysql
PostgreSQL
./cloudquery fetch --driver postgresql --dsn "host=localhost user=postgres password=pass DB.name=postgres port=5432"
To run a local PostgreSQL instance via docker:
docker run -p 5432:5432 -e POSTGRES_PASSWORD=pass -d postgres
SQL Server
./cloudquery fetch --driver sqlserver --dsn "sqlserver://sa:yourStrong(!)[email protected]:1433?database=cloudquery"
To run a local SQL Server instance via docker:
docker run -it -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest
Graph
Neo4j
Other
Neo4j
./cloudquery fetch --driver neo4j --dsn "neo4j://neo4j:[email protected]:7687"
To run a local Neo4j instance via docker:
docker run \
    -p7474:7474 -p7687:7687 \
    -d \
    -v $HOME/neo4j/data:/data \
    -v $HOME/neo4j/logs:/logs \
    -v $HOME/neo4j/import:/var/lib/neo4j/import \
    -v $HOME/neo4j/plugins:/plugins \
    --env NEO4J_AUTH=neo4j/pass \
    neo4j:latest
Other
Wanna see support for other graph database? Please open an issue:)
​
Quick Start
Deployment
Last updated 1 month ago