YstokSQL is a Common Lisp library for interfacing relational databases via ODBC. The implementation is much inspired by LispWorks CommonSQL, provides the functional interface almost in full and a limited support of the object-oriented interface.

YstokSQL is based on the following open-source implementations:

YstokSQL was tested on LispWorks 4.2-4.4 and 5.0 for Windows against the following DBMSs and ODBC drivers:


YstokSQL requires Ystok-Library.


On every Windows system after WinXP SP2 and Win2003 SP1, the Jet driver is preinstalled. If Access were chosen, database administration required by an YstokSQL application could be miserable (and MS Office is not needed).

Compatibility with Allegro CL, CLISP, Corman Lisp, CMUCL, MCL, and SBCL is targetable.

Download and installation

YstokSQL is available from http://lisp.ystok.ru/ysql/ysql-1-1-012.zip. The distribution package contains both the ASDF file ysql.asd and the LispWorks system definition file defsys.lisp.

Here is change.log.


For documentation, please refer to

Differences from Other Implementations

Changes from SQL/ODBC version 0.9 (the last Paul Meurer's release)

Differences from CommonSQL standard

Differences from CLSQL (and UncommonSQL)

Releases and New Features

Release 0.2

Release 0.3

Release 0.4

Release 1.1

See also