This syncs data from a CloudQuery source to a PostgreSQL-compatible database. Supports RDS, Prisma, Aiven, Neon, Supabase and many others. It also comes with a built-in support for pgvector extension that allows you to store, query, and index vectors.
Loading plugin documentation
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
localhost:5432:kind: destination
spec:
name: "postgresql"
registry: "github"
path: "cloudquery/postgresql"
version: "v6.1.3"
spec:
connection_string: "postgresql://postgres:pass@localhost:5432/postgres?sslmode=disable"
# can be also specified in DSN format which can hold special characters in password
# connection_string: "user=postgres password=pass+0-[word host=localhost port=5432 dbname=postgres"
# Optional parameters:
# pgx_log_level: error
# batch_size: 10000 # 10K entries
# batch_size_bytes: 100000000 # 100 MB
# batch_timeout: 60s
batch_size and batch_size_bytes.connection_string (string) (required)pgxpool"postgres://jack:secret@localhost:5432/mydb?sslmode=prefer" connect with tcp and prefer TLS"postgres://jack:secret@localhost:5432/mydb?sslmode=disable&application_name=pgxtest&search_path=myschema&connect_timeout=5" be explicit with all options"postgres://localhost:5432/mydb?sslmode=disable" connect with os username cloudquery is being run as"postgres:///mydb?host=/tmp" connect over unix socket"dbname=mydb" unix domain socket, just specifying the db name - useful if you want to use peer authentication"user=jack password=jack\\'ssooper\\\\secret host=localhost port=5432 dbname=mydb sslmode=disable" DSN with escaped backslash and single quotepgx_log_level (string) (optional) (default: error)batch_size (integer) (optional) (default: 10000)batch_size_bytes (integer) (optional) (default: 100000000 (= 100 MB))batch_timeout (duration) (optional) (default: 60s (= 60 seconds))pgx built-in logging and might output data/sensitive information to logs so make sure to not use it in production but only for debugging.kind: destination
spec:
name: postgresql
path: cloudquery/postgresql
version: "v6.1.3"
spec:
connection_string: ${PG_CONNECTION_STRING}
pgx_log_level: debug # Available: error, warn, info, debug, trace. Default: "error"