skip to navigation
skip to content

sqlcmd 0.7.1

A cross-platform, cross-database SQL command line tool

sqlcmd is a SQL command line tool, similar in concept to tools like Oracle’s SQL*Plus, the PostgreSQL psql command, and MySQL’s mysql tool.

Some features at a glance

  • Connection parameters for individual databases are kept in a configuration file in your home directory.
  • Databases can be assigned multiple logical names.
  • sqlcmd has command history management, with GNU Readline support. History files are saved per database.
  • sqlcmd supports SQL, but also supports database metadata (getting a list of tables, querying the table’s columns and their data types, listing the indexes and foreign keys for a table, etc.).
  • sqlcmd supports Unix shell-style variables.
  • sqlcmd command has a .set command that displays and controls sqlcmd settings.
  • sqlcmd provides a standard interface that works the same no matter what database you’re using.
  • sqlcmd uses the enhanced database drivers in the Grizzled API’s db module. (Those drivers are, in turn, built on top of standard Python DB API drivers like psycopg2 and MySQLdb.)
  • sqlcmd is written entirely in Python, which makes it very portable (though the database drivers are often written in C and may not be available on all platforms).

In short, sqlcmd is a SQL command tool that attempts to provide the same interface for all supported databases and across all platforms.

File Type Py Version Uploaded on Size (md5) Source 2011-03-15 59KB