manticoresoftware/manticoresearch ? reverse-engineered prompt

Build me an open source search database that feels fast and easy to use, with SQL as the main way to work with it, plus MySQL style connections and an HTTP JSON API. It should handle full text search really well, but also support vector and hybrid search so I can search by meaning and by keywords in the same system. I want real time indexing, so new documents become searchable quickly, and I want it to work on both small and large datasets without me having to think too hard about tuning it.

Please make it support basic auth and permissions, sharding and replication friendly behavior, and enough tooling so I can load data, create tables, and run searches from the command line. If any details are unclear, look up the current docs online and follow the project’s existing behavior as closely as possible. Also make sure it builds cleanly and includes a simple example config and a few smoke tests so I can verify it works.