Agent skill

obsidian-bases

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, filters, or formulas in Obsidian.

View SKILL.md on GitHub Repository

Stars 129

Forks 41

Install this agent skill to your Project

npx add-skill https://github.com/zephyrwang6/myskill/tree/main/obsidian-skills-main/obsidian-bases

SKILL.md

Obsidian Bases Skill

This skill enables Claude Code to create and edit valid Obsidian Bases (.base files) including views, filters, formulas, and all related configurations.

Overview

Obsidian Bases are YAML-based files that define dynamic views of notes in an Obsidian vault. A Base file can contain multiple views, global filters, formulas, property configurations, and custom summaries.

File Format

Base files use the .base extension and contain valid YAML. They can also be embedded in Markdown code blocks.

Complete Schema

yaml

# Global filters apply to ALL views in the base
filters:
  # Can be a single filter string
  # OR a recursive filter object with and/or/not
  and: []
  or: []
  not: []

# Define formula properties that can be used across all views
formulas:
  formula_name: 'expression'

# Configure display names and settings for properties
properties:
  property_name:
    displayName: "Display Name"
  formula.formula_name:
    displayName: "Formula Display Name"
  file.ext:
    displayName: "Extension"

# Define custom summary formulas
summaries:
  custom_summary_name: 'values.mean().round(3)'

# Define one or more views
views:
  - type: table | cards | list | map
    name: "View Name"
    limit: 10                    # Optional: limit results
    groupBy:                     # Optional: group results
      property: property_name
      direction: ASC | DESC
    filters:                     # View-specific filters
      and: []
    order:                       # Properties to display in order
      - file.name
      - property_name
      - formula.formula_name
    summaries:                   # Map properties to summary formulas
      property_name: Average

Filter Syntax

Filters narrow down results. They can be applied globally or per-view.

Filter Structure

yaml

# Single filter
filters: 'status == "done"'

# AND - all conditions must be true
filters:
  and:
    - 'status == "done"'
    - 'priority > 3'

# OR - any condition can be true
filters:
  or:
    - 'file.hasTag("book")'
    - 'file.hasTag("article")'

# NOT - exclude matching items
filters:
  not:
    - 'file.hasTag("archived")'

# Nested filters
filters:
  or:
    - file.hasTag("tag")
    - and:
        - file.hasTag("book")
        - file.hasLink("Textbook")
    - not:
        - file.hasTag("book")
        - file.inFolder("Required Reading")

Filter Operators

Operator	Description
`==`	equals
`!=`	not equal
`>`	greater than
`<`	less than
`>=`	greater than or equal
`<=`	less than or equal
`&&`	logical and
`\|\|`	logical or
!	logical not

Properties

Three Types of Properties

Note properties - From frontmatter: note.author or just author
File properties - File metadata: file.name, file.mtime, etc.
Formula properties - Computed values: formula.my_formula

File Properties Reference

Property	Type	Description
`file.name`	String	File name
`file.basename`	String	File name without extension
`file.path`	String	Full path to file
`file.folder`	String	Parent folder path
`file.ext`	String	File extension
`file.size`	Number	File size in bytes
`file.ctime`	Date	Created time
`file.mtime`	Date	Modified time
`file.tags`	List	All tags in file
`file.links`	List	Internal links in file
`file.backlinks`	List	Files linking to this file
`file.embeds`	List	Embeds in the note
`file.properties`	Object	All frontmatter properties

The `this` Keyword

In main content area: refers to the base file itself
When embedded: refers to the embedding file
In sidebar: refers to the active file in main content

Formula Syntax

Formulas compute values from properties. Defined in the formulas section.

yaml

formulas:
  # Simple arithmetic
  total: "price * quantity"
  
  # Conditional logic
  status_icon: 'if(done, "✅", "⏳")'
  
  # String formatting
  formatted_price: 'if(price, price.toFixed(2) + " dollars")'
  
  # Date formatting
  created: 'file.ctime.format("YYYY-MM-DD")'
  
  # Complex expressions
  days_old: '((now() - file.ctime) / 86400000).round(0)'

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

Date Arithmetic

yaml

# 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 for millisecond difference
"now() - file.ctime"

# 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

View Types

Table View

yaml

views:
  - type: table
    name: "My Table"
    order:
      - file.name
      - status
      - due_date
    summaries:
      price: Sum
      count: Average

Cards View

yaml

views:
  - type: cards
    name: "Gallery"
    order:
      - file.name
      - cover_image
      - description

List View

yaml

views:
  - type: list
    name: "Simple List"
    order:
      - file.name
      - status

Map View

Requires latitude/longitude properties and the Maps plugin.

yaml

views:
  - type: map
    name: "Locations"
    # Map-specific settings for lat/lng properties

Default Summary Formulas

Name	Input Type	Description
`Average`	Number	Mathematical mean
`Min`	Number	Smallest number
`Max`	Number	Largest number
`Sum`	Number	Sum of all numbers
`Range`	Number	Max - Min
`Median`	Number	Mathematical median
`Stddev`	Number	Standard deviation
`Earliest`	Date	Earliest date
`Latest`	Date	Latest date
`Range`	Date	Latest - Earliest
`Checked`	Boolean	Count of true values
`Unchecked`	Boolean	Count of false values
`Empty`	Any	Count of empty values
`Filled`	Any	Count of non-empty values
`Unique`	Any	Count of unique values

Complete Examples

Task Tracker Base

yaml

filters:
  and:
    - file.hasTag("task")
    - 'file.ext == "md"'

formulas:
  days_until_due: 'if(due, ((date(due) - today()) / 86400000).round(0), "")'
  is_overdue: 'if(due, date(due) < today() && status != "done", false)'
  priority_label: 'if(priority == 1, "🔴 High", if(priority == 2, "🟡 Medium", "🟢 Low"))'

properties:
  status:
    displayName: Status
  formula.days_until_due:
    displayName: "Days Until Due"
  formula.priority_label:
    displayName: Priority

views:
  - type: table
    name: "Active Tasks"
    filters:
      and:
        - 'status != "done"'
    order:
      - file.name
      - status
      - formula.priority_label
      - due
      - formula.days_until_due
    groupBy:
      property: status
      direction: ASC
    summaries:
      formula.days_until_due: Average

  - type: table
    name: "Completed"
    filters:
      and:
        - 'status == "done"'
    order:
      - file.name
      - completed_date

Reading List Base

yaml

filters:
  or:
    - file.hasTag("book")
    - file.hasTag("article")

formulas:
  reading_time: 'if(pages, (pages * 2).toString() + " min", "")'
  status_icon: 'if(status == "reading", "📖", if(status == "done", "✅", "📚"))'
  year_read: 'if(finished_date, date(finished_date).year, "")'

properties:
  author:
    displayName: Author
  formula.status_icon:
    displayName: ""
  formula.reading_time:
    displayName: "Est. Time"

views:
  - type: cards
    name: "Library"
    order:
      - cover
      - file.name
      - author
      - formula.status_icon
    filters:
      not:
        - 'status == "dropped"'

  - type: table
    name: "Reading List"
    filters:
      and:
        - 'status == "to-read"'
    order:
      - file.name
      - author
      - pages
      - formula.reading_time

Project Notes Base

yaml

filters:
  and:
    - file.inFolder("Projects")
    - 'file.ext == "md"'

formulas:
  last_updated: 'file.mtime.relative()'
  link_count: 'file.links.length'
  
summaries:
  avgLinks: 'values.filter(value.isType("number")).mean().round(1)'

properties:
  formula.last_updated:
    displayName: "Updated"
  formula.link_count:
    displayName: "Links"

views:
  - type: table
    name: "All Projects"
    order:
      - file.name
      - status
      - formula.last_updated
      - formula.link_count
    summaries:
      formula.link_count: avgLinks
    groupBy:
      property: status
      direction: ASC

  - type: list
    name: "Quick List"
    order:
      - file.name
      - status

Daily Notes Index

yaml

filters:
  and:
    - file.inFolder("Daily Notes")
    - '/^\d{4}-\d{2}-\d{2}$/.matches(file.basename)'

formulas:
  word_estimate: '(file.size / 5).round(0)'
  day_of_week: 'date(file.basename).format("dddd")'

properties:
  formula.day_of_week:
    displayName: "Day"
  formula.word_estimate:
    displayName: "~Words"

views:
  - type: table
    name: "Recent Notes"
    limit: 30
    order:
      - file.name
      - formula.day_of_week
      - formula.word_estimate
      - file.mtime

Embedding Bases

Embed in Markdown files:

markdown

![[MyBase.base]]

<!-- Specific view -->
![[MyBase.base#View Name]]

YAML Quoting Rules

Use single quotes for formulas containing double quotes: 'if(done, "Yes", "No")'
Use double quotes for simple strings: "My View Name"
Escape nested quotes properly in complex expressions

Common Patterns

Filter by Tag

yaml

filters:
  and:
    - file.hasTag("project")

Filter by Folder

yaml

filters:
  and:
    - file.inFolder("Notes")

Filter by Date Range

yaml

filters:
  and:
    - 'file.mtime > now() - "7d"'

Filter by Property Value

yaml

filters:
  and:
    - 'status == "active"'
    - 'priority >= 3'

Combine Multiple Conditions

yaml

filters:
  or:
    - and:
        - file.hasTag("important")
        - 'status != "done"'
    - and:
        - 'priority == 1'
        - 'due != ""'

References

Maintainer

zephyrwang6 Core maintainer

Source details

Full Name: zephyrwang6/myskill
Branch: main
Path in repo: obsidian-skills-main/obsidian-bases

Featured Tools

Join Our Newsletter

Stay updated with the latest AI tools, news, and offers by subscribing to our weekly newsletter.

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

zephyrwang6/myskill

start-work

每日工作启动助手。读取Obsidian收件箱、计划文件，提醒今日待办，询问内容创作计划，展示周计划进度，调用热点采集。触发词："开始工作"、"开启新一天"、"今天做什么"。帮助用户快速进入高效工作状态。

129 41

Explore

zephyrwang6/myskill

doc-coauthoring

Guide users through a structured workflow for co-authoring documentation, articles, or long-form content. Use when user wants to write documentation, proposals, articles, or similar structured content. This workflow helps users efficiently transfer context, refine content through iteration, and verify the doc works for readers. Trigger when user mentions writing docs, creating proposals, drafting articles, or using "co-authoring" workflow.

129 41

Explore

zephyrwang6/myskill

mem-query

AI个人记忆系统的记忆查询功能。检索各层级记忆文件，综合多层级信息回答用户问题。使用场景：(1) 用户问"我的记忆中关于XXX"时；(2) 用户询问自己的习惯/偏好/价值观时；(3) 需要基于用户历史提供建议时。该skill会自动检索L1-L4各层级，引用来源，给出基于记忆的个性化回答。

129 41

Explore

zephyrwang6/myskill

article-review

根据原文内容撰写深度文章评价/解读。当用户提供一篇文章、博客、公众号文章或任何长文内容，并要求生成评价、解读、读后感或二次创作内容时使用此技能。适用于：(1) 对技术文章、行业分析、年终总结等进行深度解读，(2) 提炼文章核心观点并用通俗语言重新表达，(3) 为社交媒体传播生成二次内容。

129 41

Explore

zephyrwang6/myskill

mem-record

AI个人记忆系统的记忆记录功能。自动从对话中提炼关键信息并记录到相应层级。使用场景：(1) 用户说"记录到记忆系统"、"记住这个"、"把这次对话记下来"时；(2) 检测到重要事件、决策、偏好表达时；(3) 用户完成重要任务或做出决策时。该skill会自动判断应该记录到L1情境层、L2行为层、L3认知层，还是建议更新L4核心层。

129 41

Explore

zephyrwang6/myskill

remotion-video

使用 Remotion 框架以编程方式创建视频。Remotion 让你用 React 组件定义视频内容，支持动画、字幕、音乐可视化、3D 视频、教程讲解视频等。适用于程序化视频、批量生成、数据驱动视频、音乐可视化、自动字幕等场景。

129 41

Explore

Didn't find tool you were looking for?

Search AI Tools

Install this agent skill to your Project

SKILL.md

Obsidian Bases Skill

Overview

File Format

Complete Schema

Filter Syntax

Filter Structure

Filter Operators

Properties

Three Types of Properties

File Properties Reference

The this Keyword

Formula Syntax

Functions Reference

Global Functions

Any Type Functions

Date Functions & Fields

Date Arithmetic

String Functions

Number Functions

List Functions

File Functions

Link Functions

Object Functions

Regular Expression Functions

View Types

Table View

Cards View

List View

Map View

Default Summary Formulas

Complete Examples

Task Tracker Base

Reading List Base

Project Notes Base

Daily Notes Index

Embedding Bases

YAML Quoting Rules

Common Patterns

Filter by Tag

Filter by Folder

Filter by Date Range

Filter by Property Value

Combine Multiple Conditions

References

Recommended Agent Skills

start-work

doc-coauthoring

mem-query

article-review

mem-record

remotion-video

The `this` Keyword