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:)