Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

Select Status

The sqitch cookbook has been deprecated

Author provided reason for deprecation:

The sqitch cookbook has been deprecated and is no longer being maintained by its authors. Use of the sqitch cookbook is no longer recommended.


sqitch (2) Versions 1.0.0

Installs sqitch for managing SQL changesets

cookbook 'sqitch', '= 1.0.0', :supermarket
cookbook 'sqitch', '= 1.0.0'
knife supermarket install sqitch
knife supermarket download sqitch
Quality 83%

sqitch cookbook

Build Status Cookbook Version

This cookbook installs sqitch, a database-agnostic change management system. It also provides LWRPs for using Sqitch to deploy database schema changes.


  • sqitch LWRP with support for deploying and reverting schema changes
  • why-run support, indicating which changesets (if any) would be deployed

Tested on PostgreSQL. Theoretically supports SQLite, Oracle, and MySQL as well, but is untested for those platforms.



  • Debian/Ubuntu
  • RHEL/CentOS/Scientific/Amazon/Oracle


  • Chef 12.1+


  • perl
  • build-essential


In general, you should just use the sqitch LWRP (it will automatically include the recipe that installs Sqitch, so you don't need to worry about that).

For example, to deploy version 2.0.0 of the myface schema, you could do:

sqitch "myface_schema" do
  action :deploy
  db_name "myface_db"
  to_target "2.0.0"
  top_dir "/path/to/myface/sqitch/dir"

Similarly, to roll back to version 1.5.0, you might have:

sqitch "myface_schema" do
  action :revert
  db_name "myface_db"
  to_target "1.5.0"
  top_dir "/path/to/myface/sqitch/dir"

Please consult the documentation in /resources/default.rb for complete details on the LWRP.


  • node['sqitch']['engine'] Controls which driver module is installed, as well as which one is used by the LWRP. Defaults to pg for PostgreSQL.


  • default - Installs Sqitch, as well as necessary driver modules for the databases it supports.


Additional documentation can be generated using [Yard].

bundle install
rake yard

You can view the documentation in your browser by running a yard server:

yard server --reload -B localhost --plugin yard-chef

License & Authors

Author: Cookbook Engineering Team (

Copyright: 2008-2016, Chef Software, Inc.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
See the License for the specific language governing permissions and
limitations under the License.

Dependent cookbooks

perl >= 1.0.0
build-essential >= 0.0.0

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

sqitch Cookbook CHANGELOG

This file is used to list changes made in each version of the sqitch cookbook.

v1.0.0 (2016-09-16)

  • Require Chef 12.1
  • Require build-essential cookbook

v0.6.0 (2016-07-13)

PR #3 - Include mysql support josephholsten

Collaborator Number Metric

1.0.0 passed this metric

Contributing File Metric

1.0.0 passed this metric

Foodcritic Metric

1.0.0 failed this metric

FC122: Use the build_essential resource instead of the recipe: sqitch/recipes/default.rb:8
Run with Foodcritic Version 14.0.0 with tags metadata,correctness ~FC031 ~FC045 and failure tags any

No Binaries Metric

1.0.0 passed this metric

Testing File Metric

1.0.0 passed this metric

Version Tag Metric

1.0.0 passed this metric