Can I use the same repository for VersionSQL as other software?

Yes! VersionSQL creates a /VersionSQL/ directory in the repository, so committed SQL can coexist cleanly alongside other code.