List all providers for the current tenant.
Returns providers with their deployment status. Providers that have been pushed but not deployed will have deployment_status=None.
Args: service: Provider service for provider operations.
Returns: List of ProviderInfo with provider metadata and deployment status.