Add back sqllite/chroma tests to client tests

[cpacker]

Describe the bug

Dev portal send_message seems broken on latest main when using non-postgres install. Should add back unit testing for the local install to the client to handle non-postgres now that we are distributing dev portal on pip.