You can obtain details about the database, including the name, ID, libSQL server version, group, size and location. 
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.