Should be. AFAIK psycopg2 works with Redshift just fine, so should asyncpg.

The only thing I'm not sure about is what kind of authentication mode Redshift is using. asyncpg doesn't support all of them, but that's easy to fix.

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