Pages

About

BareSQL.com is the home of BareSQL, one small program with two tools for SQL databases. BareSQL Audit tells you which PostgreSQL login can read which column, and how. …

BareSQL Audit

BareSQL Audit logs in to a PostgreSQL database and works out, for every login, each column it can read and the route that gets it there. It marks the columns that hold …

BareSQL Portable

BareSQL Portable checks SQL that has to run on SQLite, PostgreSQL, MySQL and MariaDB. It knows 58 differences between those engines: 35 where at least one engine refuses …

Contact

BareSQL.com would like to hear from anyone who tries BareSQL, about what it found and what it missed. Bug reports help most: an audit line the server disagrees with, a …

Download BareSQL

The baresql command is one file with nothing else to install. Each archive below holds it with its license files, the README and the changelog. The links always point to …

Quick Start

BareSQL is one program, baresql. BareSQL Audit is its audit and diff commands, and BareSQL Portable is lint, compare and rules. Get it from the download page and check …

Reference

Every command and flag of baresql, as of version 0.1.0. baresql help lists the commands in the terminal and baresql help COMMAND shows the flags of one. A flag works with …

Sample Reports

These reports are exactly what BareSQL Audit wrote for the databases its tests build. Each database is made up, with invented people in it, and planted with mistakes that …