Haven't tried, but, AFAIK, redshift speaks the standard PostgreSQL protocol, so asyncpg should work.