cloudquery currently supports two types of databases: Relational - SQLite, MySQL, PostgreSQL, SQL Server and graph - Neo4j.
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
./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
./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
./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
./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
Wanna see support for other graph database? Please open an issue:)