Use of HTSQL with open source databases (PostgreSQL, MySQL, SQLite) is royalty free under BSD-style conditions. Usage of HTSQL with proprietary database systems (Oracle, Microsoft SQL) requires a commercial license. See HTSQL Licensing.

After installing HTSQL, please see our HTSQL Handbook.

Debian / Ubuntu

If you’re running a Debian or Ubuntu system, you can install HTSQL from our APT repository:

# wget -q -O - | apt-key add -
# echo 'deb stable free' >> /etc/apt/sources.list
# apt-get update
# apt-get install htsql

You need to install additional packages to use HTSQL with a database other than SQLite. For PostgreSQL:

# apt-get install htsql-pgsql

For MySQL:

# apt-get install htsql-mysql

RedHat EL / CentOS

We provide RPM packages for RedHat Enterprise Linux 6 or CentOS 6.


You may need to add the EPEL repository to satisfy the dependency on PyYAML.

To include HTSQL RPM repository, run:

# rpm -Uvh

Now you can install HTSQL:

# yum install HTSQL

To install PostgreSQL or MySQL backend, run:

# yum install HTSQL-PGSQL
# yum install HTSQL-MYSQL

HTRAF Toolkit

HTRAF is a toolkit for embedding data into HTML pages. HTRAF is written in Javascript and released under dual MIT/GPL license.

The latest build of HTRAF could be downloaded from

Install from Source

To install HTSQL from source, please read Installing HTSQL.