Index of every page on this site: llms.txt
All skills
obsidianmd avatar

/obsidian-bases

@b110b2f
by Obsidianobsidianmd/obsidian-skills53k stars
3,795
Run it yourself

Create and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries. Use when working with .base files, creating database-like views of notes, or when the user mentions Bases, table views, card views, kanban boards, filters, or formulas in Obsidian.

Use this Skill: https://skilld.dev/gh/obsidianmd/obsidian-skills/obsidian-bases

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

referencesFUNCTIONS_REFERENCE.md

≈1.9k tokens on demand. Your agent reads this file only when SKILL.md points to it.

Functions Reference

Global Functions

Function Signature Description
date() date(string): date Parse string to date. Format: YYYY-MM-DD HH:mm:ss
duration() duration(string): duration Parse duration string
now() now(): date Current date and time
today() today(): date Current date (time = 00:00:00)
if() if(condition, trueResult, falseResult?) Conditional
min() min(n1, n2, ...): number Smallest number
max() max(n1, n2, ...): number Largest number
number() number(any): number Convert to number
link() link(path, display?): Link Create a link
list() list(element): List Wrap in list if not already
file() file(path): file Get file object
image() image(path): image Create image for rendering
icon() icon(name): icon Lucide icon by name
html() html(string): html Render as HTML
escapeHTML() escapeHTML(string): string Escape HTML characters

Any Type Functions

Function Signature Description
isTruthy() any.isTruthy(): boolean Coerce to boolean
isType() any.isType(type): boolean Check type
toString() any.toString(): string Convert to string

Date Functions & Fields

Fields: date.year, date.month, date.day, date.hour, date.minute, date.second, date.millisecond

Function Signature Description
date() date.date(): date Remove time portion
format() date.format(string): string Format with Moment.js pattern
time() date.time(): string Get time as string
relative() date.relative(): string Human-readable relative time
isEmpty() date.isEmpty(): boolean Always false for dates

Duration Type

When subtracting two dates, the result is a Duration type (not a number). Duration has its own properties and methods.

Duration Fields:

Field Type Description
duration.days Number Total days in duration
duration.hours Number Total hours in duration
duration.minutes Number Total minutes in duration
duration.seconds Number Total seconds in duration
duration.milliseconds Number Total milliseconds in duration

IMPORTANT: Duration does NOT support .round(), .floor(), .ceil() directly. You must access a numeric field first (like .days), then apply number functions.

# CORRECT: Calculate days between dates
"(date(due_date) - today()).days"                    # Returns number of days
"(now() - file.ctime).days"                          # Days since created

# CORRECT: Round the numeric result if needed
"(date(due_date) - today()).days.round(0)"           # Rounded days
"(now() - file.ctime).hours.round(0)"                # Rounded hours

# WRONG - will cause error:
# "((date(due) - today()) / 86400000).round(0)"      # Duration doesn't support division then round

Date Arithmetic

# Duration units: y/year/years, M/month/months, d/day/days,
#                 w/week/weeks, h/hour/hours, m/minute/minutes, s/second/seconds

# Add/subtract durations
"date + \"1M\""           # Add 1 month
"date - \"2h\""           # Subtract 2 hours
"now() + \"1 day\""       # Tomorrow
"today() + \"7d\""        # A week from today

# Subtract dates returns Duration type
"now() - file.ctime"                    # Returns Duration
"(now() - file.ctime).days"             # Get days as number
"(now() - file.ctime).hours"            # Get hours as number

# Complex duration arithmetic
"now() + (duration('1d') * 2)"

String Functions

Field: string.length

Function Signature Description
contains() string.contains(value): boolean Check substring
containsAll() string.containsAll(...values): boolean All substrings present
containsAny() string.containsAny(...values): boolean Any substring present
startsWith() string.startsWith(query): boolean Starts with query
endsWith() string.endsWith(query): boolean Ends with query
isEmpty() string.isEmpty(): boolean Empty or not present
lower() string.lower(): string To lowercase
title() string.title(): string To Title Case
trim() string.trim(): string Remove whitespace
replace() string.replace(pattern, replacement): string Replace pattern
repeat() string.repeat(count): string Repeat string
reverse() string.reverse(): string Reverse string
slice() string.slice(start, end?): string Substring
split() string.split(separator, n?): list Split to list

Number Functions

Function Signature Description
abs() number.abs(): number Absolute value
ceil() number.ceil(): number Round up
floor() number.floor(): number Round down
round() number.round(digits?): number Round to digits
toFixed() number.toFixed(precision): string Fixed-point notation
isEmpty() number.isEmpty(): boolean Not present

List Functions

Field: list.length

Function Signature Description
contains() list.contains(value): boolean Element exists
containsAll() list.containsAll(...values): boolean All elements exist
containsAny() list.containsAny(...values): boolean Any element exists
filter() list.filter(expression): list Filter by condition (uses value, index)
map() list.map(expression): list Transform elements (uses value, index)
reduce() list.reduce(expression, initial): any Reduce to single value (uses value, index, acc)
flat() list.flat(): list Flatten nested lists
join() list.join(separator): string Join to string
reverse() list.reverse(): list Reverse order
slice() list.slice(start, end?): list Sublist
sort() list.sort(): list Sort ascending
unique() list.unique(): list Remove duplicates
isEmpty() list.isEmpty(): boolean No elements

File Functions

Function Signature Description
asLink() file.asLink(display?): Link Convert to link
hasLink() file.hasLink(otherFile): boolean Has link to file
hasTag() file.hasTag(...tags): boolean Has any of the tags
hasProperty() file.hasProperty(name): boolean Has property
inFolder() file.inFolder(folder): boolean In folder or subfolder

Link Functions

Function Signature Description
asFile() link.asFile(): file Get file object
linksTo() link.linksTo(file): boolean Links to file

Object Functions

Function Signature Description
isEmpty() object.isEmpty(): boolean No properties
keys() object.keys(): list List of keys
values() object.values(): list List of values

Regular Expression Functions

Function Signature Description
matches() regexp.matches(string): boolean Test if matches

Source: SKILL.md on GitHub

No rule matched.

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts7d3 checks · Risk SAFE
  • Gen Agent Trust Hub7d

    The obsidian-bases skill facilitates the management of database-like views within an Obsidian vault. It presents a low-risk profile due to its inherent processing of untrusted note data and the use of a domain-specific formula language. The primary security considerations involve potential indirect prompt injection from note properties and the exposure of sensitive vault metadata to the agent's context.

  • Socket7d

    No alerts

  • Snyk7d

    Risk: LOW · No issues

Signed by skilld at b110b2f. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 12 hours ago.

Activeupdated last week
  • Database
  • obsidian
  • bases
  • yaml
  • formulas
  • filters
  • views
  • table
  • cards

README badge

README badge for obsidianmd/obsidian-skills/obsidian-bases

Creates and edits Obsidian Bases (.base files) — YAML-structured database views of notes with filters, formulas, and multiple view types (table, cards, list, map). Use this skill when working with .base files, creating filtered note collections, or computing properties with formulas in Obsidian.

Generated from the current SKILL.md.

Does this skill work with Obsidian Bases (.base files)?
Yes. This skill creates and edits .base files with views, filters, formulas, and summaries. It handles table, cards, list, and map view types.
What filter operators are supported?
The skill supports ==, !=, >, <, >=, <=, &&, ||, and ! operators, plus nested AND/OR/NOT filter structures for complex queries.
Can I create computed properties in a Base?
Yes. Define formulas in the `formulas` section using expressions with arithmetic, conditional logic, string formatting, and date functions. Formulas can then be referenced as `formula.formula_name` in views and filters.
How do I calculate the difference between two dates?
Subtract dates to get a Duration type, then access the numeric field (e.g., `(date(due_date) - today()).days` for days as a number). Duration does not support .round() directly; access the field first, then apply number functions.
What are the YAML quoting rules?
Wrap formulas containing double quotes in single quotes (e.g., `'if(done, "Yes", "No")'`). Quote strings with special characters like colons. Avoid nested double quotes inside double quotes.

Generated from the current SKILL.md. These answers refresh after source changes.