Neon.tech Integration
Neon.tech is an open-source cloud database platform that provides fully managed PostgreSQL databases with high availability and scalability.
As a Postgres database service provider, Neon.tech follows the regular Postgres protocol and therefore can be integrated as any PostgreSQL resource.
-
Get a Connection string. You can obtain it connection string from the Connection Details widget on the Neon Dashboard: select a branch, a role, and the database you want to connect to and a connection string will be constructed for you.
-
From Windmill, add your Neon.tech connection string as a Postgresql resource and Execute queries.
Adding the connection string as a Postgres resource requires to parse it.
For example, for psql postgres://daniel:<password>@ep-restless-rice.us-east-2.aws.neon.tech/neondb
, that would be:
{
"host": "ep-restless-rice.us-east-2.aws.neon.tech",
"port": 5432,
"user": "daniel",
"dbname": "neondb",
"sslmode": "require",
"password": "<password>"
}
Where the sslmode should be "require" and Neon uses the default PostgreSQL port, 5432
.