Accessing User Information and Executing Queries in Stalwart with Docker

[kunalkamble17]

Hey Stalwart Community,

I’ve recently set up a Stalwart server using Docker and switched the database to PostgreSQL through the admin panel. I've also created several users through the accounts section of the admin page. Now, I’m looking to understand a few things:

Where are the Users Stored?

Can anyone tell me where the user information is stored within Stalwart? I’d like to know how to locate this data.
Accessing User List from CLI

How can I access and view the list of users from the command line interface (CLI)? Are there specific commands or queries I need to run?
Executing Lookup Queries in Docker

I’d also appreciate guidance on executing lookup queries within Docker. What’s the best way to run SQL queries against the PostgreSQL database that’s running in my Docker container?
Thanks in advance for your help!

[mdecimus]

Hi, this document explains where the information is stored. User information is stored in either the internal or external directory