pgDuckDB Hosting Live In 5 Minutes

Deploy pgDuckDB hosting and run analytical SQL on PostgreSQL 18 without a separate warehouse. xCloud runs the pinned pg_duckdb 1.1.1 image as one container, generates the database name, user and password, mounts the pgduckdb_data volume and allocates a TCP port for your clients. It is a data service, so there is no web page and no domain; restrict the port to the addresses that need it.

Deploy your pgDuckDB

No terminal
No technical skills needed
No lock-in, cancel anytime

What is pgDuckDB?

pgDuckDB packages pg_duckdb, the PostgreSQL extension that integrates DuckDB's columnar-vectorized analytics engine into PostgreSQL, so you can run analytical SQL without leaving the database. Upstream says it automatically uses DuckDB to execute your existing queries when duckdb.force_execution is set, and reads Parquet, CSV, JSON, Iceberg and Delta Lake files from object storage. Self-hosted pgDuckDB is a Postgres analytics database for teams that might otherwise reach for a hosted warehouse such as Snowflake or Amazon Redshift, under the MIT licence.

On xCloud it is PostgreSQL 18 with pg_duckdb 1.1.1 preloaded, as one upstream image pinned by digest, with data on the pgduckdb_data volume. xCloud generates the database name, user and password and allocates a TCP port. It is a data service, so there is no web page or domain, and the port is public with no TLS.

From Sign-Up to a Live pgDuckDB In Just 3 Easy Steps

A PostgreSQL analytics database normally means an image, the extension, a volume, generated credentials and a published port before the first query. This is the same result without assembling any of it.

Step 01
Sign Up
Create your xCloud account and pick pgDuckDB from the OneClick catalog. Choose your target server; there are no extra fields to fill in and no domain to configure.
Step 02
We Deploy It For You
One click. We start the upstream pgduckdb image for PostgreSQL 18 and pg_duckdb 1.1.1, pinned by digest, mount pgduckdb_data, generate the database name, user and password, and allocate the TCP port.
Step 03
Connect And Run A Query
Copy the host, port, database and password from the credentials, connect with psql, confirm the pg_duckdb extension is installed, then run an analytical SELECT. Restrict the public port to your client addresses first.

Everything pgDuckDB Does, On Your Own Server

pgDuckDB runs in full here: DuckDB-powered analytics inside a PostgreSQL 18 database that you own.

DuckDB Engine Inside Postgres
Run your existing analytical SQL as usual; with duckdb.force_execution set, pg_duckdb executes it in DuckDB's columnar-vectorized engine.
No Export Step
pg_duckdb works directly with your regular PostgreSQL tables, so there is no need to export data to Parquet or another format first.
Data Lake Reads
Read Parquet, CSV, JSON, Iceberg and Delta Lake files from S3, GCS, Azure and R2 as if they were tables.
Join Local And Remote Data
Combine a PostgreSQL table with a remote Parquet file in one query, aggregating each side before the join.
Optional MotherDuck Compute
Upstream supports MotherDuck as a compute provider. It is disabled here until you add a token in the Environment editor.
Persistent PostgreSQL Volume
Tables, roles and the extension live on pgduckdb_data, which holds the PostgreSQL 18 data directory and survives a restart.

Everything You Need To Run Your Analytics Database 24/7

Managed hosting for pgDuckDB, so the parts that keep it online are not your problem.

pgDuckDB 1.1.1 deployed instantly
Upstream image pinned by digest
Database user and password generated
Persistent pgduckdb_data volume
Server backups and snapshots
Server security updates included
Choose your server region
Unused balance refunded

What You Can Do With pgDuckDB

Speed up analytical queries on Postgres tables
Run aggregations over large orders or events tables through DuckDB's engine, without exporting the data into another system.
Query Parquet files in a data lake
Join a PostgreSQL table with a Parquet file in S3, GCS, Azure or R2 in one SELECT, using read_parquet.
Keep analytics beside the app database
Give an analytics team one PostgreSQL endpoint on your own server instead of a separate hosted warehouse.
Try DuckDB without leaving SQL
Use psql or any PostgreSQL client you already have to test DuckDB-backed queries on a dedicated, disposable server.

pgDuckDB vs Alternatives

Snowflake: A hosted cloud data warehouse run by its vendor. Self-hosted pgDuckDB brings DuckDB's analytics engine into a PostgreSQL 18 database that you run yourself, with MIT-licensed software.
Amazon Redshift: A hosted warehouse inside one cloud provider. pgDuckDB runs on any Cloud VPS you choose, and queries data in PostgreSQL tables or in S3, GCS, Azure and R2 files from one connection.
ClickHouse: ClickHouse is a separate analytical database server. In the pgDuckDB vs ClickHouse choice, pgDuckDB keeps analytics inside PostgreSQL, so your existing tables, roles and clients carry on unchanged.
PostgreSQL: PostgreSQL has its own OneClick page. pgDuckDB is PostgreSQL 18 with the pg_duckdb extension preloaded for analytical queries, so choose it when your workload is analytics-heavy.

Ready To Run Your Own Analytics Database?

pgDuckDB on xCloud runs on a dedicated Cloud VPS that we provision, patch, monitor and restore. Deploy faster. Own your data. Stay in control.

Fast Provisioning
Deploy faster using an xCloud Managed Server built with optimized stacks and high-speed SSDs.
Enterprise-grade security
Protect your infrastructure with a free SSL certificate and more advanced security features at no additional cost.
Intuitive Control Panel
From Server creation to application deployment, everything can be managed from our intuitive control panel.

Hear what people are saying about us

See why agencies, developers, startups, and growing businesses choose xCloud to power their projects.

xCloud works really well, I am surprised by its performance being this the release version, I have tried many paid platforms such as runcloud, cloudpages or serveravatar, as well as free platforms such as CyberPanel, CloudPanel or Hestia Control Panel and direct competitors such as SpinupWP and FlyWP. Of all those that I have tried, the platform that works best for WordPress is SpinupWP and I believe that xCloud can reach and surpass that development, its roadmap is promising. Congratulations to the xCloud team, I hope they become the leading platform in the segment, it has all the potential to achieve it!

Brian Geovanny

I've been with runcloud for the last 3 years. However, after trying xcloud for the last month, I'm switching over. They are on a roll with their setup.

Kevin Pineda

I'm moving my servers to xCloud, a cloud control panel by M Asif Rahman and the WPDeveloper team. Their roadmap looks interesting and no, there are no team mates nor API limits with xCloud! #xCloud #wordpress #hosting

Leo Koo

How Cloud Nine Web Elevated Client Experience While Streamlining Hosting Operations using xCloud

Ed Ellingham

xCloud is like having an expert server team on call — without the big agency costs. It's given me back my time and given my clients peace of mind. Highly recommended for freelancers and small teams who want reliable performance and security.

Dumitru Butucel

xCloud isn't just a solution. It's like one of that friend who got your back when you screw things up pretty bad.

Waqar Ahmed

Trust me when I say, once people explore the potential of xCloud they gonna switch from other panels, just keep delivering the best tech, lots of love for the team 😍😍

Rahul Singh

So far my experience has been smooth like silk. I didn't imagine that configuring and managing a VPS would be so easy. As of today, I have deployed 8 sites. The support is good, and they treat users with respect, even if they ask stupid questions (myself included). For the future, I hope for greater flexibility in scheduled backups and more comprehensive and consistent documentation. I'm sure that within a few months, xCloud will become the leader in its segment. This community is amazing, and the Staff here is super helpful.

Massimo Villa

Came from cloudways then to runcloud then to xcloud. Looks like I'm staying here.

Gerson El

I've recently taken all of my Vultr-hosted sites and gotten rid of cPanel for them to substitute it with xCloud. I have to say, I'm really impressed with xCloud so far! The interface is definitely the standout feature for me.

Tony Lewis

I came from Cloudways and won't go back. Highly impressed with xCloud. Glad I gave them a chance.

Jared McDowell

I like xCloud better than RunCloud, but one thing I'll point out is that some years ago RunCloud was hungry for business, the support was outstanding, and the community was active and helped each other. Maybe it was sold, there was a change in management, or they stopped being hungry, but the quality of the RunCloud offering declined and it hasn't been moving forward quickly. My point is that currently the xCloud team has the edge and it is theirs to keep or lose

David McCan

How Kevin Heinrichs Cut Hosting Costs by 84% While Running WooCommerce & Node.js Sites Efficiently

Kevin Heinrichs

I had 150 sites on cloudways and am in the process of moving them to xcloud. Much faster and better priced.

Dan Spinoza

Dear xCloud Team, I have been using xCloud for some time now and am genuinely impressed with its capabilities and the flexibility it offers by allowing users to bring their own VPS for management. It's a fantastic service, and my experience so far has been very positive. Successful migrated 5 sites on a single server. Xcloud migration tool worked great. There were few hiccups with security plugin like MalCare but disabling the plugin prior to migration worked just fine.

Rahil Maknojia

Came from runcloud. Tried xcloud and never came back.

Karl Fanega

How Advanced Web Strategies Saved Over $2,000 & Recovered 56 Hours per Month Managing 70+ Client Websites

Gary Moody

xCloud gave me what no other hosting platform could: the flexibility of a VPS with the convenience of managed WordPress. As a solo founder running an entire business on one server, that combination is an important unfair advantage.

Jorge de los Reyes Martínez

I use Server Avatar and xCloud and I'll sooner use xCloud than Server Avatar personally.

Jay Pagano

How Newman Web Solutions Ensured Perfect Uptime and Seamless Scaling For 120+ WordPress Sites with xCloud

Lori Newman

I too have moved over to xCloud. It's pretty sweet. One click n8n and uptime Kuma apps

John Aperture

I went from Cloudways to xCloud. No intention on switching in the foreseeable future.

Blaine Moore

Frequently Asked Questions

Feel free to contact us with any questions or concerns you may have.

Can you self-host pgDuckDB with Docker?

Yes. This template is pgDuckDB Docker hosting with the setup done: the upstream pgduckdb image for PostgreSQL 18 and pg_duckdb 1.1.1 pinned by digest, one pgduckdb_data volume, generated credentials and an allocated TCP port. It gives you your own pgDuckDB cloud database on a dedicated server.

How much RAM does pgDuckDB need?

The template manifest asks for 1024 MB of memory, 1 core and 5 GB of storage. The 6 GB plan is the entry rung here. Analytical queries over large tables or Parquet files use more memory and disk than that floor, so size up as your data grows.

Is pgDuckDB open source?

Yes. pg_duckdb carries the MIT licence, and its README says it was built with Hydra and MotherDuck. No licence fee applies; the only cost is the Cloud VPS hosting it, which you can cancel whenever you wish.

How do I connect to a pg_duckdb PostgreSQL instance?

Use the host, port, database, username and password from the installation credentials with any PostgreSQL client, such as psql, using a postgresql:// connection string. xCloud generates the user, database name and a 32-character password, and the password is revealable in the credentials panel.

How do I query Parquet files from PostgreSQL with pg_duckdb?

Call read_parquet with an S3 path in your SELECT; upstream shows creating a simple S3 secret first with duckdb.create_simple_secret, then reading the file as a table. CSV, JSON, Iceberg and Delta Lake are also readable from S3, GCS, Azure and R2, per its README.

Can pg_duckdb replace a data warehouse?

For analytics on data you keep in PostgreSQL or in object storage, it can run those queries through DuckDB's engine. This template is one PostgreSQL node on one server, so it is not a managed multi-node warehouse; test your workload and size before moving a warehouse over.

Is the pgDuckDB port exposed to the internet?

Yes. The raw PostgreSQL port is reachable from outside the server, and this baseline configures no TLS. Restrict it to trusted client addresses with your firewall, and use a private network, VPN or SSH tunnel for production traffic. There is no web page or domain.

Does pgDuckDB support MotherDuck?

Upstream supports MotherDuck as a compute provider, but it is disabled by default here. To enable it, add MOTHERDUCK_TOKEN in the Environment editor after installation and use the app lifecycle action to apply it. Treat the token as a secret and never put it in Git or screenshots.

Can I rotate the pgDuckDB database credentials?

Not by editing the environment. POSTGRES_USER, POSTGRES_PASSWORD and POSTGRES_DB initialise the database only while its data directory is empty, so later edits do not change existing roles. Use PostgreSQL's SQL role-management commands to rotate a password on a running database.

How do I back up pgDuckDB?

Back up the pgduckdb_data volume, which holds the PostgreSQL 18 data directory with your tables and roles. For a consistent copy of a running database, use PostgreSQL's own pg_dump as well, keep the copies off the server, and try a restore on a separate install first.

Backups in xCloud

How do I upgrade pgDuckDB?

The install stays on the pinned 18-v1.1.1 image until you adopt a newer template version. Read the pg_duckdb release notes, back up pgduckdb_data and take a dump first, then redeploy and confirm the extension and a representative query. Nothing upgrades automatically.

Can I cancel anytime?

Yes. There is no lock-in — cancel any time. Hosting is billed monthly and charged for what you actually use, so when you delete the server the unused balance is refunded to your account, less up to 10% in payment-processing fees.