You can obtain details about the database, including the name, ID, libSQL server version, group, size and locations.

turso db show <database-name> [flags]

You can also obtain the different URLs for the database using the following:

Flags

FlagDescription
--urlShow URL for the database HTTP API.
--http-urlShow HTTP URL for the database HTTP API.
--instance-urlsShow individual instance URLS for primary and replica instances.