How to get mysql and other plugin item keys in zabbix_agent2 -p output?

[sagarpa]

I have installed zabbix_agent2 - 6.6.0 and following are details related to it.

zabbix_agent2 (Zabbix) 6.4.6
Revision 52b7e2cb506 22 August 2023, compilation time: Aug 22 2023 12:09:42
Plugin communication protocol version is 6.4.0​

I have configured mysql plugin using session named with uri, user and password details as per documentation
Configuration :

Plugins.Mysql.Sessions.Prod.Uri=tcp://localhost:3306
Plugins.Mysql.Sessions.Prod.User=zabbix
Plugins.Mysql.Sessions.Prod.Password=XXXXXX​

restarted zabbix_agents

After executing

zabbix_agent2 -p

command, mysql items are not listed in the output. On trying with

zabbix_agent2 -t mysql.ping[Prod]

, i can see the result output as below.

zabbix_agent2 -t mysql.ping[Prod]
mysql.ping[Prod]                              [s|1]​

I would like to get all metrics output using

zabbix_agent2 -p

command. Is it possible to achieve?

Note: I just want to use only zabbix_agent2 and integrate to my application without using zabbix server.