The best way is to extract the archive to Tcl lib directory.
It is normally the parent directory of director in Tcl global variable Tcl_library.
Extract XOSql archive in any place but load the directory to Tcl auto_path global variable.
Here an example of quick shell installation and usage
[artur@localhost artur]$ tar -xzf /home/joachim/public_html/xosql/xosql-0.61.tar.gz
[artur@localhost artur]$ cd xosql/
[artur@localhost xosql]$ /opt/tcl845-debug/bin/tclsh8.4
% package require XOTcl
1.1
% namespace import xotcl::*
% lappend auto_path .
/opt/tcl845-debug//lib/tcl8.4 /opt/tcl845-debug/lib /opt/tcl845-debug//lib .
% package require xdobry::sql
0.55
% Sqlinterface loadInterface mysqltcl
MySql
% MySql create sql
::sql
% sql connect {user root dbank xotcllib}
1
% sql queryList {select * from Userlib}
{1 artur {Artur Trzewik}} {2 joachim {Joachim Trzewik}}
%
Tk Connection Dialog
XOSql has small Tk connection dialog to use common dialog for DB connection.
It supports also passing arguments as defaults.
For connect mysql use "IDEDBConnectDialog setConnectionOn MySql". If parameter is empty the user can choose the interface "IDEDBConnectDialog setConnectionOn {}". You can also pass some default values (as returned from getconnectionargs) "IDEDBConnectDialog setConnectionOn MySql {user root host 127.0.0.1}"