The equivalent PoSh would be:
Get-SPDatabase | select NormalizedDataSource,DisplayName,TypeName,Status
To get the detailed status of a particular content database, run:
$database = Get-SPDatabase -Name DatabaseName
$database | select Server,DisplayName,Status,IsReadOnly,SchemaVersionXml,FailoverServiceInstance,WarningSiteCount,MaximumSiteCount,PreferredTimerServiceInstance