=======================
 sqlite-utils |version|
=======================

|PyPI| |Changelog| |CI| |License|

.. |PyPI|
   :target: https://pypi.org/project/sqlite-utils/
.. |Changelog|
   :target: https://sqlite-utils.datasette.io/en/stable/changelog.html
.. |CI|
   :target: https://github.com/simonw/sqlite-utils/actions
.. |License|
   :target: https://github.com/simonw/sqlite-utils/blob/main/LICENSE

*CLI tool and Python utility functions for manipulating SQLite databases*

This library and command-line utility helps create SQLite databases from an existing collection of data.

Most of the functionality is available as either a Python API or through the ``sqlite-utils`` command-line tool.

sqlite-utils is not intended to be a full ORM: the focus is utility helpers to make creating the initial database and populating it with data as productive as possible.

It is designed as a useful complement to `Datasette <https://datasette.io/>`_.

Contents
--------

.. toctree::
   :maxdepth: 3

   installation
   cli
   python-api
   reference
   cli-reference
   contributing
   changelog
