add query history functionality with database integration

fixes

feat: add connection endpoint and update schema indexing functionality

code push