PostgreSQL

aid: postgres
name: PostgreSQL
description: >-
  PostgreSQL is a powerful, open-source object-relational database system with
  over 35 years of active development that has earned a strong reputation for
  reliability, feature robustness, and performance. It supports advanced SQL
  features, JSON, full-text search, custom data types, extensions, and
  transactional DDL. PostgreSQL does not expose a native HTTP REST API;
  client applications connect via the libpq C client library, JDBC, ODBC,
  or one of dozens of language-specific drivers using the PostgreSQL wire
  protocol (default port 5432).
type: Index
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
tags:
  - Database
  - Relational Database
  - SQL
  - Open Source
  - PostgreSQL
  - Object-Relational
  - Data Storage
url: >-
  https://raw.githubusercontent.com/api-evangelist/postgres/refs/heads/main/apis.yml
created: '2026-05-11'
modified: '2026-05-11'
specificationVersion: '0.19'
apis:
  - aid: postgres: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
  - aid: postgres: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: postgres: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: postgres: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: Website
    url: https://www.postgresql.org
  - type: Documentation
    url: https://www.postgresql.org/docs/
  - type: Download
    url: https://www.postgresql.org/download/
  - type: Source Code
    url: https://git.postgresql.org/gitweb/?p=postgresql.git
  - type: GitHub Mirror
    url: https://github.com/postgres/postgres
  - type: Mailing Lists
    url: https://www.postgresql.org/list/
  - type: Community
    url: https://www.postgresql.org/community/
  - type: License
    url: https://www.postgresql.org/about/licence/
features:
  - name: ACID Transactions
    description: >-
      Full ACID-compliant transactions with multiple isolation levels including
      serializable snapshot isolation (SSI) for true serializable execution.
  - name: Advanced SQL
    description: >-
      Comprehensive SQL standard support including window functions, common
      table expressions (CTEs), recursive queries, lateral joins, and more.
  - name: JSON and JSONB
    description: >-
      First-class JSON and binary JSONB column types with rich operators,
      indexing (GIN), and path expressions for document-style workloads.
  - name: Extensions
    description: >-
      Pluggable extension system enabling PostGIS (geospatial), pgvector
      (vector embeddings), TimescaleDB, pg_stat_statements, and hundreds more.
  - name: Replication and HA
    description: >-
      Streaming replication, logical replication, hot standbys, and
      synchronous replication for high availability and read scaling.
  - name: Full-Text Search
    description: >-
      Built-in full-text search with tsvector/tsquery, ranking, multiple
      languages, and integration with GIN/GiST indexes.
solutions:
  - name: OLTP Application Database
    description: >-
      Primary transactional database for web applications, SaaS products,
      and enterprise systems requiring strong consistency and reliability.
  - name: Geospatial Data Platform
    description: >-
      Industry-standard geospatial database via the PostGIS extension for
      mapping, GIS, location services, and spatial analytics.
  - name: Vector Database for AI
    description: >-
      Store and query embedding vectors using pgvector for retrieval-augmented
      generation (RAG), semantic search, and recommendation systems.
useCases:
  - name: SaaS Application Backend
    description: >-
      Multi-tenant relational backend for SaaS apps using row-level security,
      schemas, and JSONB for flexible per-tenant data.
  - name: Analytics and Reporting
    description: >-
      Operational analytics workloads using window functions, CTEs, and
      columnar extensions like Citus or Hydra.
  - name: Geospatial Applications
    description: >-
      Mapping, routing, and location-aware applications using PostGIS for
      spatial queries, geometries, and tiled map data.
integrations:
  - name: PostGIS
    description: Geospatial extension adding geometry, geography, and raster types
  - name: pgvector
    description: Vector similarity search extension for AI/ML embeddings
  - name: TimescaleDB
    description: Time-series database extension built on PostgreSQL
  - name: PostgREST
    description: Auto-generated REST API gateway exposing PostgreSQL tables as endpoints
  - name: pgAdmin
    description: Open-source administration and development platform for PostgreSQL
  - name: Hasura
    description: GraphQL API engine that auto-generates a GraphQL layer over PostgreSQL
maintainers:
  - FN: Kin Lane
    email: [email protected]