Official Turso Cloud support in Lucid (not only local libSQL)

[zz9rodes]

Hello 👋 @RomainLanz @thetutlage

First, thank you for the amazing work on AdonisJS Lucid
.

I would like to suggest improving the documentation around Turso
/ libSQL
support in Lucid.

Current issue

The current documentation only shows a local SQLite/libSQL configuration:

const dbConfig = defineConfig({
  connection: 'libsql',

  connections: {
    libsql: `{`
      client: 'libsql',

      connection: {
        filename: env.get('DB_DATABASE', 'tmp/db.sqlite3'),
      },
    },
  },
})

This makes it look like the libsql driver only supports local SQLite files.

However, Turso/libSQL also supports remote cloud connections using:

url
authToken

as documented in the official @libsql/client SDK.

Suggestion

It would be very helpful to add official documentation for Turso Cloud usage.

1. Add a Turso Cloud example

const dbConfig = defineConfig({
  connection: 'libsql',

  connections: {
    libsql: {
      client: 'libsql',

      connection: {
        url: env.get('DB_URL'),
        authToken: env.get('DB_AUTH_TOKEN'),
      },

      useNullAsDefault: true,

      migrations: {
        naturalSort: true,
        paths: ['database/migrations'],
      },
    },
  },
})

2. Add a dedicated section

Possible section names:

“Using Turso Cloud”
“Remote libSQL connections”
“libSQL local vs remote”
Why this matters

Right now, many developers assume that:

Lucid only supports local SQLite
Turso Cloud is not compatible
or that they must stop using Lucid and switch directly to @libsql/client

because the remote/cloud configuration is not documented.