6
7- **Blob Storage**: Read, write, list, and delete blob data
8- **SQLite Database**: Execute queries and manage database operations
9- **Email**: Send emails through Val Town's email service
10- **OpenAI Integration**: Access OpenAI API through Val Town's service
45 }
46
47 // Add database schema as a resource
48 resources.push({
49 uri: "sqlite://schema",
50 name: "SQLite Schema",
51 description: "Database schema information",
52 mimeType: "application/json"
53 });
146 };
147 } catch (error) {
148 throw new MCPException(MCP_ERRORS.INTERNAL_ERROR, `Error reading database schema: ${error.message}`);
149 }
150 }
34 - `blob_delete` - Delete blob
35
362. **SQLite Database**
37 - `sqlite_execute` - Execute SQL queries
38
54- `blob://[key]` - Blob storage items
55- `file://[path]` - Project files
56- `sqlite://schema` - Database schema
57- `env://info` - Environment variable info
30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
4
5The directory is a simple
6database of Date Me Docs. Date Me Docs are long-form, earnest dating profiles for romantic partners.
7[Learn more here](https://dateme.directory/faq).
8
9## Todos
10
11- [ ] Make the SQLite database forkable and build a widget/workflow for that, ie fix @stevekrouse/dateme_sqlite
12- [ ] Require an email (that isn't shared publicly)
13 - [ ] Verify the email address with a "magic link"
345 }
346 } catch (e) {
347 console.error("Database error:", e);
348 await email({
349 subject: "Date Me Doc Submit Error: " + body["Name"],
383 );
384};
385// Database migration to add UserEmail column if it doesn't exist
386async function ensureUserEmailColumn() {
387 try {
4
5The directory is a simple
6database of Date Me Docs. Date Me Docs are long-form, earnest dating profiles for romantic partners.
7[Learn more here](https://dateme.directory/faq).
8
9## Todos
10
11- [ ] Make the SQLite database forkable and build a widget/workflow for that, ie fix @stevekrouse/dateme_sqlite
12- [ ] Require an email (that isn't shared publicly)
13 - [ ] Verify the email address with a "magic link"
12 console.log(data);
13 try {
14 // create a database page in the interactions database
15 const page = await setAction(data);
16 // console.log(page);
10 const page = await notion.pages.create({
11 parent: {
12 database_id: Deno.env.get("GLANCE_INTERACTIONS_DB_ID"),
13 },
14 properties: {
8
9 // get each of the actions from this demo from Notion
10 // data is stored in the "Glancer interactions" database and attached to the demo via relation
11 // we can't really use the relation property b/c that only holds an array of page IDs in Notion
12 // so, in Notion, we use a formula to transform the relation array into a string