cockroachdb/cockroach ? reverse-engineered prompt

Build me a cloud native distributed SQL database that feels like PostgreSQL to use, but can scale out across multiple machines and keep working even if a node or even a whole datacenter goes down.

I want a local version I can run on my machine for development, with a built in SQL shell so I can connect, create tables, insert data, and query it like a normal database. It should handle transactions safely, keep data replicated, and automatically rebalance things when nodes join or leave. Please make it easy to build from source, run tests, and start a small cluster for experimentation.

If there are any tricky implementation details or current best practices I should follow, look up the latest docs online and use those. I care most about reliability, simplicity for the user, and a clean developer experience.