opaleye: An SQL-generating DSL targeting PostgreSQL

[ bsd3, database, library ] [ Propose Tags ]

An SQL-generating DSL targeting PostgreSQL. Allows Postgres queries to be written within Haskell in a typesafe and composable fashion.

[Skip to Readme]


Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees


Versions [RSS] 0.2, 0.3, 0.3.1,,,,,,,,,,,,,,,,, 0.6.7000.0, 0.6.7001.0, 0.6.7002.0, 0.6.7003.0, 0.6.7003.1, 0.6.7004.0, 0.6.7004.1, 0.6.7004.2, 0.6.7005.0, 0.6.7006.0, 0.6.7006.1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (info)
Change log CHANGELOG.md
Dependencies aeson (>=0.6 && <1.6), base (>=4.9 && <5), base16-bytestring (>= && <0.2), bytestring (>=0.10 && <0.11), case-insensitive (>=1.2 && <1.3), contravariant (>=1.2 && <1.6), postgresql-simple (>=0.5.3 && <0.7), pretty (>= && <1.2), product-profunctors (>= && <0.12), profunctors (>=4.0 && <5.6), scientific (>=0.3 && <0.4), semigroups (>=0.13 && <0.20), text (>=0.11 && <1.3), time (>=1.4 && <1.10), time-locale-compat (>=0.1 && <0.2), transformers (>=0.3 && <0.6), uuid (>=1.3 && <1.4), void (>=0.4 && <0.8) [details]
License BSD-3-Clause
Copyright Copyright (c) 2014-2018 Purely Agile Limited; 2019-2020 Tom Ellis
Author Purely Agile
Maintainer Purely Agile
Category Database
Home page https://github.com/tomjaguarpaw/haskell-opaleye
Bug tracker https://github.com/tomjaguarpaw/haskell-opaleye/issues
Source repo head: git clone https://github.com/tomjaguarpaw/haskell-opaleye.git
Uploaded by tomjaguarpaw at 2020-08-22T12:42:25Z
Distributions LTSHaskell:, NixOS:
Reverse Dependencies 8 direct, 2 indirect [details]
Downloads 31078 total (252 in the last 30 days)
Rating 2.5 (votes: 4) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs available [build log]
Last success reported on 2020-08-22 [all 1 reports]

Readme for opaleye-

[back to package description]

Brief introduction to Opaleye Hackage version Linux build status

Opaleye is a Haskell library that provides an SQL-generating embedded domain specific language for targeting Postgres. You need Opaleye if you want to use Haskell to write typesafe and composable code to query a Postgres database.

"Opaleye really is great. You've managed to bring what is so wonderful about relational databases and give it type safety and composition (i.e. what is wonderful about Haskell)" – Daniel Patterson, Position Development

"We use it for most of our DB code. It's very flexible and almost always as performant as manually written queries" – Adam Bergmark, Silk.co

"Opaleye is absolutely fantastic. It has been solid in production for years!" – Matt Wraith

"Opaleye just works, and it’s my personal recommendation ... I like it a lot" – William Yao

Opaleye allows you to define your database tables and write queries against them in Haskell code, and aims to be typesafe in the sense that if your code compiles then the generated SQL query will not fail at runtime. A wide range of SQL functionality is supported including inner and outer joins, restriction, aggregation, distinct, sorting and limiting, unions and differences. Facilities to insert to, update and delete from tables are also provided. Code written using Opaleye is composable at a very fine level of granularity, promoting code reuse and high levels of abstraction.

Getting Opaleye


Please get started with Opaleye by referring to these two tutorials



Contact the author

The main author of Opaleye is Tom Ellis. He can be contacted via email.

File bugs

Please file bugs on the Opaleye GitHub issue tracking page.

Discuss and ask questions about Opaleye

You are welcome to use the Opaleye GitHub issue tracking page for discussion of or questions about Opaleye even if they don't relate to a bug or issue.

Internal modules

Opaleye exports a number of modules named Opaleye.Internal..... They are provided in case of urgent need for access to the internals, but they are not intended to be used by API consumers and if you find yourself repeatedly accessing them this is a sign that either you or Opaleye are doing something wrong. In such a case please file a bug.

The interface of Internal modules does not follow the PVP and may break between minor releases, so be careful.

Running tests

You must have running PostgreSQL server to run tests. Specify the database by setting the POSTGRES_CONNSTRING environment variable:

POSTGRES_CONNSTRING="user=tom dbname=opaleye_test" stack test

Commercial support

Commercial support for Opaleye is provided by Purely Agile.

Backup maintainers

In the event of the main developer becoming unreachable, please contact the following who are authorised to make bugfixes and dependency version bumps:

  • Adam Bergmark
  • Erik Hesselink
  • Oliver Charles


The Opaleye Project was founded by Tom Ellis, inspired by theoretical work on databases by David Spivak. Much of the implementation was based on ideas and code from the HaskellDB project by Daan Leijen, Conny Andersson, Martin Andersson, Mary Bergman, Victor Blomqvist, Bjorn Bringert, Anders Hockersten, Torbjorn Martin, Jeremy Shaw and Justin Bailey.

The following individuals and organisations made helpful contributions which were important in helping to get the project off the ground.

  • Silk (Erik Hesselink, Adam Bergmark)
  • Karamaan (Christopher Lewis)
  • Fynder (Renzo Carbonara, Oliver Charles)
  • Daniel Patterson
  • Jakub Ryška
  • Travis Staton

Joseph Abrahamson, Alfredo Di Napoli and Mietek Bak performed useful reviews of early versions which helped improve the codebase. Since then there have been helpful contributions from many others. Thanks to them all for their help.