francisyzy/telegraf-sqlite-template — reverse-engineered prompt

Build me a simple Telegram bot starter project that I can reuse for small bots. I want it in TypeScript using Telegraf, with a local SQLite database through Prisma so I don’t need to set up any outside database service.

The bot should be easy to run after I add my Telegram bot token to a .env file. When someone sends /start, it should reply with a friendly welcome message and save basic info about the Telegram user in the local database if they are new. Add a simple /help command too, and keep the code organized so I can add more commands later without digging through everything.

Please include the setup files, an example env file, database migration setup, and npm scripts for installing, running in development, migrating the database, building, and starting in production. Make sure secrets aren’t committed. Add a short README that explains how to create the .env file and run the bot locally. Look up current docs online if you need to.