pingcap/tidb ? reverse-engineered prompt

Build me a cloud native distributed SQL database like TiDB, with MySQL compatibility, so apps can connect to it with normal MySQL tools and drivers without changing much. I want it to handle transactions safely across multiple nodes, stay available if a machine fails, and scale up or out without downtime. It should support both fast transactional queries and analytical queries on the same data, and it would be great if it also includes vector search support for AI style workloads.

Please set up a clean local development experience too, so I can run it, test it, and try a small demo cluster on my machine. If you need to look up current docs or best practices online while wiring things together, go ahead. Make sure the result feels production ready, with sensible defaults, clear startup steps, and basic docs for how to run it and connect to it.