WARNING: This web is not used anymore. Please use PDBService.SqlPython instead!


SQLPython is a SQL command-line client designed with extensibility and personalization in mind.


SQLPython is a command line tool written in python with the following goals:

  • emulate Oracle's sqlplus basic functionalities in python
  • allow easy extensions to sqlplus functionalities leveraging python's class inheritance
  • allow to consolidate custom sql scripts into new SQLPython commands
  • allow to jump out the sql environment into python to post process query result sets
  • new: sqlpython originally developed as an Oracle CLI, is being extended for more DB platforms


Author: Luca Canali
Co-author and main developer currently: Catherine Devlin
Feedback to: luca.canali -at- cern.ch, http://canali.web.cern.ch/canali
Latest version on this wiki: 1.3.0, ChangeLog
Current version:, May 2009 (see pipy.python.org)

How to get started (applies only to legacy version 1.3.0):

Dependencies: python 2.2 or higher, cx_Oracle, and Oracle client.
Download, untar and start with ./run (or from the python command line with 'import mysqlpy'). Click this link to download SQLpython source:


  • README, description and basic instructions
  • sqlpython.py - the core module, lean implementation of the main sqlplus functionalities in python
  • sqlpyPlus.py - extention to sqlpython
  • mysqlpy.py - Extention with custom functionality (dba-oriented) and default entry-point for sqlpython. See header file.
  • run - jump-start shell script

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatext README r10 r9 r8 r7 r6 manage 4.3 K 2007-02-05 - 19:07 LucaCanali sqlpython V1.2.5 readme file (to be updated to 1.3.0)
Compressed Zip archivetar sqlpython.tar r13 r12 r11 r10 r9 manage 70.0 K 2007-10-20 - 11:18 LucaCanali sqlpython V1.3.0, rev 18-Oct-2007
Edit | Attach | Watch | Print version | History: r29 < r28 < r27 < r26 < r25 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r29 - 2009-05-14 - LucaCanali
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback