You can obtain details about the database, including the name, ID, version, group, size and locations. You can also obtain the different URLs for the database using the following command:

turso db show <database-name> [flags]

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.