There's not really any such thing as a read-only DBI connection, only users who don't have permission to make changes. To divine whether the user you're logged in as has permission to make changes, you need to query the database's metadata tables. Unfortunately, what these are called, where you find them, and what they contain will differ from one RDBMS to another. If, as is likely, you're using MySQL, then see this.