select sql from sqlite_master
where tbl_name='my_table_name'
and type='index'
you can find the index name and column names in ‘sql’ field.
See also:
How to get index column names of a table from DB2
How to get index column names of a table from SQL Server
How to get index column names of a table from MySQL
How to get index column names of a table from PostgreSQL
How to get index column names of a table from Oracle
Some SQLite tools you can try: https://www.withdata.com/sqlite/
