Short example of how to access the replica databases from PAWS.

Credententials for the MySQL database, along with the name of the host to connect to, are passed in via environment variables. Note that there's a 30minute limit on the query execution times.

The database names are 'dbname of wiki' followed by '_p'. So English Wikipedia is enwiki_p, commons is commonswiki_p, meta is metawiki_p, wikidata is wikidatawiki_p, Tamil Wikisource is tawikisource_p, etc. You can see the database schema here