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.

1. Sign-up to Neon's Cloud App or Self-Host it.

2. Set up a project and add data.

3. 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.

4. From Windmill, add your Neon.tech connection string as a Postgresql resource and Execute queries.

tip

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.