I installed the libsqlite3-tcl package ("aptitude install
libsqlite3-tcl") Debian squeeze, but no libtclsqlite3.so file was
created.

I looked for:

/usr/lib/tcltk/sqlite3/libtclsqlite3.so
/usr/lib/tclsqlite3.so

I did a:

$ locate libtclsqlite3.so
$ find /usr/lib/ -iname tclsqlite3.\*so
$ objdump --syms tclsqlite3.so
objdump: 'tclsqlite3.so': No such file

I also checked to see if the library was statically linked:

$ ldd /usr/bin/tclsh8.5
linux-vdso.so.1
libtcl8.5.so.0
libdl.so.2
libpthread.so.0
libm.so.6
libc.so.6
/lib64/ld-linux-x86-64.so.2

The /usr/share/doc/libsqlite3-tcl/README file says to untar and
compile. That is not a proper process for a debian package. The
tarballs referenced in README do not seem to exist either.