Get project details

Retrieves detailed information about a specific project including its current status, region, database host, and configuration.