PostgreSQL

aid: postgresql
name: PostgreSQL
description: PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development.
  It provides advanced SQL compliance, ACID transactions, and extensibility. PostgreSQL exposes a binary wire protocol via
  libpq and language bindings rather than a public HTTP REST API, so there is no canonical OpenAPI specification. HTTP access
  is typically layered on top via PostgREST, Hasura, or application code.
type: Index
deliveryModel:
  model: unknown
  open_source: false
  commercial: false
  callable_host: false
  label: Delivery model not determined — needs a product licence on record
  confidence: low
  source:
  - none
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/postgresql.png
tags:
- Database
- Open-Source
- Relational Database
- SQL
tags_raw:
- Database
- Open Source
- Relational Database
- SQL
url: https://raw.githubusercontent.com/api-evangelist/postgresql/refs/heads/main/apis.yml
created: '2026-03-16'
modified: '2026-04-28'
specificationVersion: '0.23'
apis:
- aid: postgresql:postgresql
  name: PostgreSQL
  description: Open-source relational database with advanced SQL compliance and extensibility. Client libraries available
    in many languages.
  humanURL: https://www.postgresql.org/
  tags:
  - Database
  - SQL
  properties:
  - type: Documentation
    url: https://www.postgresql.org/docs/
  - type: GettingStarted
    url: https://www.postgresql.org/docs/current/tutorial.html
- aid: postgresql:wire-protocol
  name: PostgreSQL Wire Protocol
  description: The PostgreSQL frontend/backend protocol is the low-level message-based protocol used by all client drivers
    (libpq, JDBC, ODBC, psycopg, pgx, node-postgres, etc.) to communicate with the PostgreSQL server over TCP/IP or Unix sockets.
    Authentication supports password, SCRAM-SHA-256, MD5, GSSAPI, SSPI, certificate, LDAP, and other pluggable methods.
  humanURL: https://www.postgresql.org/docs/current/protocol.html
  baseURL: postgresql://hostname:5432
  tags:
  - Database
  - Wire Protocol
  - SQL
  - Connection Protocol
  properties:
  - type: Documentation
    url: https://www.postgresql.org/docs/current/protocol.html
  - type: Specification
    url: https://www.postgresql.org/docs/current/protocol-message-formats.html
  - url: graphql/postgres-graphql.md
    type: GraphQL
- aid: postgresql:libpq
  name: libpq C Client Library
  description: libpq is the official C application programmer's interface to PostgreSQL and the underlying library used by
    most other PostgreSQL client interfaces. It provides connection management, query execution, prepared statements, COPY
    support, asynchronous operations, and SSL/TLS.
  humanURL: https://www.postgresql.org/docs/current/libpq.html
  baseURL: postgresql://hostname:5432
  tags:
  - Database
  - C Library
  - Client Library
  - libpq
  properties:
  - type: Documentation
    url: https://www.postgresql.org/docs/current/libpq.html
- aid: postgresql:jdbc
  name: PostgreSQL JDBC Driver
  description: The official Type 4 JDBC driver for PostgreSQL enables Java applications to connect to PostgreSQL using the
    standard JDBC API. It supports connection pooling, prepared statements, batched updates, LOBs, COPY, and SSL connections.
  humanURL: https://jdbc.postgresql.org/documentation/
  baseURL: jdbc:postgresql://hostname:5432/database
  tags:
  - Database
  - JDBC
  - Java
  - Driver
  properties:
  - type: Documentation
    url: https://jdbc.postgresql.org/documentation/
  - type: GitHub
    url: https://github.com/pgjdbc/pgjdbc
- aid: postgresql:odbc
  name: PostgreSQL ODBC Driver (psqlODBC)
  description: The official ODBC driver for PostgreSQL providing Open Database Connectivity for Windows, Linux, and macOS
    applications including Microsoft Office, Tableau, Power BI, and other BI/ETL tools that consume ODBC data sources.
  humanURL: https://odbc.postgresql.org/
  baseURL: Driver={PostgreSQL};Server=hostname;Port=5432;Database=mydb
  tags:
  - Database
  - ODBC
  - Driver
  - BI Integration
  properties:
  - type: Documentation
    url: https://odbc.postgresql.org/docs/
  - type: GitHub
    url: https://github.com/postgresql-interfaces/psqlodbc
common:
- type: DomainSecurity
  url: security/postgresql-domain-security.yml
- type: Website
  url: https://www.postgresql.org/
- type: Documentation
  url: https://www.postgresql.org/docs/
- type: Community
  url: https://www.postgresql.org/community/
- type: GitHubOrganization
  url: https://github.com/postgres/postgres
- url: https://www.postgresql.org/news.rss
  type: Blog
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com