[Haskell-cafe] ANN: Groundhog-inspector, a tool for generating datatypes from database

Boris Lykah lykahb at gmail.com
Thu Dec 4 17:07:25 UTC 2014

Hello everyone,

I am pleased to announce groundhog-inspector. It analyzes database schema
and creates corresponding datatypes and mapping configuration for
Groundhog. It works with PostgreSQL, MySQL, and Sqlite. Composite keys,
constraints, references across schemas, and other details of schema are
reflected in the output. Groundhog-inspector can be used as a library and
provides a standalone tool for simple scenarios.

Here is an example of the standalone tool usage. JSON mapping in the output
was manually converted to YAML for brevity.

$ sqlite3 dbfile "CREATE TABLE mytable (id INTEGER PRIMARY KEY NOT NULL,
str VARCHAR NOT NULL, ref INTEGER references mytable)"

$ groundhog_inspector sqlite dbfile

data Mytable
    = Mytable {mytableStr :: String,
               mytableRef :: (Maybe (AutoKey Mytable))}

- entity: "Mytable"
  dbName: "mytable"
    - name: "Mytable"
        - name: "mytableStr"
          dbName: "str"
        - name: "mytableRef"
          dbName: "ref"

* [Hackage] (http://hackage.haskell.org/package/groundhog-inspector)
* [GitHub] (

I would be happy to answer the questions. Enjoy!

Boris Lykah
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.haskell.org/pipermail/haskell-cafe/attachments/20141204/5e3d6e77/attachment.html>

More information about the Haskell-Cafe mailing list