Devart Python Connector for PostgreSQL: A Commercial DB API Driver for Postgres
Devart Python Connector for PostgreSQL is a paid Python database module, $74.95 a year for one developer, that connects Python 3.10-3.15 code on Windows, macOS and Linux straight to PostgreSQL 8.0 through 18 and to hosted Postgres services such as Amazon Aurora, Azure, Google Cloud, AlloyDB, Heroku Postgres and CockroachDB. It follows the Python DB API 2.0 standard, installs with pip, and adds built-in SSH and HTTP tunneling, tunable connection pools and pgvector support.
Most Python developers start with psycopg, the free and very capable PostgreSQL driver, and for most projects that's the right call. Devart's connector is for the cases where something extra is worth paying for: a database that's only reachable through an SSH jump host or an HTTPS tunnel, an old 8.x server still in production, OAuth sign-in, or a company policy that wants a vendor with a support contract behind every database component.
Quick facts
- Version: 1.4.0, released October 22, 2026; first released December 1, 2023
- Developer: Devart
- Package:
pip install devart-postgresql-connector, or wheel files from Devart's download page (4.40 MB for Windows, 6.22 MB for macOS) - Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
- Servers: PostgreSQL 8.0 to 18, Amazon RDS for PostgreSQL, Amazon Aurora, Aurora DSQL, Azure Database for PostgreSQL, Google Cloud for PostgreSQL, AlloyDB, Heroku Postgres, CockroachDB
- Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
- Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
- Trial: 30 days, for evaluation only, not for production use
- Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
- What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription ($149.95 perpetual, $189.95 a year for Team), and PyPI and Devart's download page both showed version 1.4.0 with wheels for Python 3.10 to 3.15, on November 17, 2026. We didn't run it against a PostgreSQL server
Download Free Trial Buy Now
Overview
Using it looks like any DB API module: import devart.postgresql as postgresql, then postgresql.connect(Server=..., Database=..., UserId=..., Password=...), a cursor, execute() and fetchall(). Parameters use ? placeholders passed as a list or tuple, which keeps values out of the SQL text and protects against injection. Extra connection parameters cover the port (5432 by default), the schema search path and the protocol version.
The connector speaks the PostgreSQL wire protocol over TCP/IP itself, so no libpq or other client library has to be installed on each machine, and it ships as compiled wheels for each Python version and platform. A license is activated in code with devart.postgresql.license.activate("<key>"), and devart.postgresql.license.summary shows what's installed.
Features
Tunnels and encryption built in
Devart Python Connector for PostgreSQL can reach a server over SSL/TLS, through an SSH tunnel, or through an HTTP/HTTPS tunnel, with no separate tunnelling tool. Version 1.3 added password-protected private keys for SSL and bearer-token authentication for the HTTP tunnel, and 1.4 added an SNI option for SSL connections.
New authentication and protocol support
Devart Python Connector for PostgreSQL 1.4 added OAUTHBEARER authentication (the OAuth sign-in introduced in PostgreSQL 18), PostgreSQL protocol version 3.2, a ReadOnly connection option, and settings for client character set, time zones and treating materialized views as tables. It also fixed prepared statements piling up on the server.
Postgres-specific data handling
Devart Python Connector for PostgreSQL maps every PostgreSQL type to a Python type, with options to control the mapping, and supports the pgvector extension (since 1.2), array types, virtual generated columns and COPY ... TO STDOUT for fast exports. It's Unicode-compliant, so multilingual data reads and writes correctly.
Connection pools you can tune
Devart Python Connector for PostgreSQL pools connections once you set connection_pool.enabled = True, with min_size, max_size, lifetime and validate settings and several numbered pools chosen by a PoolId. Pooled connections are checked every 30 seconds, idle ones are dropped after about four minutes, and a fatal error on one connection triggers a check of the whole pool.
Benefits
- One less moving part. SSH or HTTPS tunnelling lives in the connection settings instead of a separate process.
- Simple deployment. A pip install, with no PostgreSQL client libraries to ship to each user's PC.
- Old and new servers. One driver for a PostgreSQL 8.x machine that's never been upgraded and a PostgreSQL 18 cluster.
- A vendor behind it. Paid support and yearly releases that follow new Python and PostgreSQL versions.
Real-World Uses
- Reporting through a bastion host. An analyst's Python script queries a production database that only accepts SSH, without hand-built port forwarding.
- AI search on Postgres. A service stores and queries embeddings in pgvector columns on Aurora or AlloyDB.
- Migrating off an old server. A script reads tables from a PostgreSQL 8.4 machine and loads them into Azure Database for PostgreSQL.
- Read-only dashboards. A reporting job opens ReadOnly connections so it can never change production data by mistake.
Who It's For, and Who Should Skip It
The connector suits Python developers and data teams in companies that need tunnelled connections, OAuth sign-in, very old or very new PostgreSQL versions, or a commercially supported driver with a license and support contract behind it.
Skip it for hobby projects and open-source libraries: the license forbids building Python packages on it for public distribution or sale, and psycopg (or asyncpg for async code) handles ordinary connections for free. It also won't help with Python 3.9 or older, and it has no async API.
Usage Guide
- Install with
pip install devart-postgresql-connector, or download the zip of wheels for your Python version and run pip on the .whl file. - After buying, copy the activation key from the order email or Devart's customer portal and run
devart.postgresql.license.activate("<key>") once. - Connect:
conn = postgresql.connect(Server="db.example.com", Database="sales", UserId="report", Password="..."), adding Port, Schema or SSL, SSH and HTTP tunnel parameters as needed. - Query:
cur = conn.cursor(), cur.execute("SELECT id, name FROM customers WHERE country = ?", ["DE"]), cur.fetchall(). - For a web app, turn on pooling with
devart.postgresql.connection_pool.enabled = True and set max_size and lifetime.
Before you buy
Code written for psycopg uses %s placeholders and different connection keywords, while Devart's examples use ? and names like Server and UserId, so moving an existing project over takes some edits. The subscription license also checks its status online, so a server with no internet access needs the perpetual license.
Where it falls short
- Not open source. You can't read or patch the code, and redistributing it needs an OEM license.
- Linux is 64-bit x86 only. The wheels cover manylinux x86_64; there's no ARM Linux build.
- No asyncio API. It's a standard synchronous DB API 2.0 driver; async frameworks are better served by asyncpg or psycopg 3's async mode.
- Per-developer licensing. A Single license is for one user; a team of up to four needs the Team license.
Comparisons
Devart vs. psycopg
psycopg (2 and 3) is free, open source and the standard PostgreSQL driver for Python, with async support and a huge user base. Devart Python Connector for PostgreSQL costs $74.95 a year but adds built-in SSH and HTTP tunnelling, no client library, servers back to PostgreSQL 8.0, tunable pools and vendor support. Pay for it only when one of those solves a real problem for you.
Python connector vs. Devart's ODBC driver for PostgreSQL
Devart also sells PostgreSQL connectivity as an ODBC driver, which serves Excel, Power BI and any ODBC tool as well as Python through pyodbc. It costs $139.95 a year for a desktop; if your only consumer is Python code, the $74.95 Python connector is cheaper and lighter, and if reports and scripts both need PostgreSQL, the ODBC driver covers both.
Editions and Pricing
| License | 1-year subscription | Perpetual | Who can use it |
|---|
| Single | $74.95 | $149.95 | One developer at one company site |
| Team | $189.95 | On the order page | Up to 4 developers at one company site |
| Site | $339.95 | On the order page | Unlimited developers at one company site |
Buy Now opens the order with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for shipping the connector inside your own product is arranged with Devart separately.
FAQs
Does Devart's PostgreSQL connector work with Amazon Aurora and Azure?
Yes. Devart Python Connector for PostgreSQL lists Amazon RDS, Amazon Aurora and Aurora DSQL, Azure Database for PostgreSQL, Google Cloud, AlloyDB, Heroku Postgres and CockroachDB among its supported servers.
Does Devart Python Connector for PostgreSQL support Python 3.9?
No. Devart Python Connector for PostgreSQL 1.4 supports Python 3.10 to 3.15; version 1.4 removed 3.7, 3.8 and 3.9.
Can I use it with pgvector for embeddings?
Yes. Devart Python Connector for PostgreSQL has supported the pgvector extension since version 1.2, released October 2024.
Can I ship the Devart connector inside an application I sell?
Only with an OEM license. Devart Python Connector for PostgreSQL's Single, Team and Site licenses cover developing and deploying your own scripts and applications within one company; redistributing the connector, or building public Python packages on it, needs OEM terms.
Does the subscription keep working offline?
No. Devart Python Connector for PostgreSQL's subscription license needs an internet connection to activate and check its status, and stops when the term ends. The perpetual license runs a specific version without a subscription.
Can I get a refund on Devart Python Connector for PostgreSQL?
Possibly. Devart Python Connector for PostgreSQL's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.
System Requirements
- Python 3.10, 3.11, 3.12, 3.13, 3.14 or 3.15 with pip
- Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
- PostgreSQL 8.0 to 18, local or a supported cloud service
- Internet access for activating and checking a subscription license
Conclusion
Devart Python Connector for PostgreSQL is worth $74.95 a year to a company that needs something psycopg makes harder: tunnelled connections without extra tooling, OAuth sign-in, a very old PostgreSQL server, or a supported commercial component. For an ordinary app talking to a modern Postgres server, psycopg does the job for free, and the closed license rules this connector out for open-source work. If one of its extras fits your setup, test it with the 30-day trial against your own database.
Download Free Trial Buy Now