This page lists details on how to connect to various databases in Bahmni.
Bahmni comprises of different sub-components, like OpenMRS, OpenELIS, OpenERP/Odoo, Dcm4chee, PACS-Integration service, etc. Each component talks to its own database, which may be created within MySQL or Postgres. To see the contents of a particular database, you will need to use the right command line tool for MySQL or Postgres, and also appropriate credentials.
MySQL Database Server
For MySQL Databases, the mysql command is used to connect to mysql databases, and view tables and data. Please refer to this resource to see all the commonly used MySQL Commands: MySQL Cheatsheet
Note: If you are connecting to MySQL running inside a Vagrant Box (or a VM) from your host machine, you will need to connect to IP: 192.168.33.10 and port: 3306.
For PostgreSQL Databases, the psql command is used to connect to PostgreSQL databases, and view tables and data. Please refer to this resource to see all the commonly used commands: PostgreSQL DB Administration Commands. If you want to use a graphical GUI tool for psql, then you can try out PgAdmin.
To connect to PostgreSQL DB as admin, and alter databases, or drop them use the command: "psql -Upostgres".