Skip to main content
Warning: You are using the test version of PyPI. This is a pre-production deployment of Warehouse. Changes made here affect the production instance of TestPyPI (
Help us improve Python packaging - Donate today!

PostgreSQL foreign data wrapper for Elasticsearch

Project Description

esfdw is a PostgreSQL foreign data wrapper for Elasticsearch.

Elasticsearch is widely used for document and log data storage, in particular as part of the ELK stack. esfdw allows PostgreSQL to be used as a query engine for data stored in Elasticsearch. Use cases include:

  • Writing SQL JOIN queries against Elasticsearch documents and letting the PostgreSQL engine do the heavy lifting
  • Running window functions on data stored in Elasticsearch
  • Applying PostgreSQL aggregations that do not currently have a native Elasticsearch equivalent

esfdw depends on Multicorn, a PostgreSQL extension for writing foreign data wrappers in Python.

Release History

Release History

This version
History Node


Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting